mqtt -> flattenjosn -> spiltjson -> evajsonpath
Data received by MQTT:
{"device_name":"Device37","device_id":"GanghuaLianXian","date":"2021-09-24 17:45:44","sensor":[{"sensor_id":"Data05_37_alarm","value ":"0"},{"sensor_id":"Data06_37_alarm","value":"0"},{"sensor_id":"Data07_37_alarm","value":"0"},
],"status":1 }
Parsing json:
"sensor":[{"sensor_id":"Data05_37_alarm","value":"0"},{"sensor_id":"Data06_37_alarm","value":"0"},{"sensor_id":"Data07_37_alarm", "值":"0"},
],
Merge the json:
{"device_name":"Device37","device_id":"GangHuaLianXian","date":"2021-09-24 17:45:44","sensor_id":"Data05_37_alarm","value":"0"} ,
{"device_name":"Device37","device_id":"GangHuaLianXian","date":"2021-09-24 17:45:44","sensor_id":"Data06_37_alarm","value":"0"} ,
{"device_name":"Device37","device_id":"GangHuaLianXian","date":"2021-09-24 17:45:44","sensor_id":"Data07_37_alarm","value":"0"} ,
How to achieve?