I have to integrate EMQX with Clickhouse using Data bridge but I am not able to parse following json using SQL Query to insert in Clickhouse.
{
“ts”: “1.701154469008E12”,
“device”: “XYZ”,
“values”: [
{
“name”: “GMDevice_V_1”,
“value”: 43648
},
{
“name”: “GMDevice_V_2”,
“value”: 43648
},
{
“name”: “GMDevice_V_3”,
“value”: 43648
}
]
}
I have created following rule but it doesn’t extract ts and device
FOREACH
payload.values
DO
clientid,
item.name as name,
item.ts as time,
item.device as device,
item.value as value
INCASE
item.value >= 0
FROM “v1/devices/me/telemetry”