Split Json Array and send it to grafana

General
1

Hi guys! I'm really new here and I got a question, I hope it's easy to understand but I don't know how to explain it well.

I've got a MQTT node that receive a JSON array with 10 JSON Object of 4 values. Something like this

[
{"AcX": 1625, "AcY": -225, "AcZ": 1235, "time": 3000},
{"AcX": 1625, "AcY": -25, "AcZ": 1556, "time": 6000},
{"AcX": 1625, "AcY": -132, "AcZ": 1789, "time": 9000},
{"AcX": 1625, "AcY": -67, "AcZ": 345, "time": 12000}
....
]

Then I feed the JSON Array into a 'Split node' to send every single object to influxdb and then display the values in grafana. The problem is that the 4th value of the object (time) is not taken care and when I display the values in grafana they collapse into one point because the timestamp value is not read. How should I solve this? Is there some function that I could write ore else? Every value in the object is read after 3 seconds. Thanks a lot!

2

Your "time" value is not a timestamp and so InfluxDB treats it just like another number. If you want InfluxDB to use the time value as the timestamp to store the other values against, you will need to convert that number into a timestamp that InfluxDB recognises. Check out the InfluxDB website on what format to use.

3

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.