H,
I am reading time-series data using HTTP plugin of Telegraf but do not know how to parse the returned JSON file. As it is time-series data, in each returned JSON file there are multiple values of the same parameter(accelerometerX/Y/Z ), as shown below. Is there a way to parse the JSON with JSON v2 parser please?
Many thanks,
Jamie
$values": [
{
“$id”: “3”,
“iotSensorMeasuredDateTime”: “2023-06-20T14:25:36.878”,
“accelerometerXMs2”: -0.95,
“accelerometerYMs2”: 0.02,
“accelerometerZMs2”: 0.0
},
{
“$id”: “4”,
“iotSensorMeasuredDateTime”: “2023-06-20T14:25:36.866”,
“accelerometerXMs2”: -0.93,
“accelerometerYMs2”: 0.02,
“accelerometerZMs2”: -0.02
},
{
“$id”: “5”,
“iotSensorMeasuredDateTime”: “2023-06-20T14:25:36.858”,
“accelerometerXMs2”: -0.95,
“accelerometerYMs2”: 0.02,
“accelerometerZMs2”: 0.0
},
{
“$id”: “6”,
“iotSensorMeasuredDateTime”: “2023-06-20T14:25:36.846”,
“accelerometerXMs2”: -0.95,
“accelerometerYMs2”: 0.0,
“accelerometerZMs2”: 0.0
},
{
“$id”: “7”,
“iotSensorMeasuredDateTime”: “2023-06-20T14:25:36.838”,
“accelerometerXMs2”: -0.95,
“accelerometerYMs2”: 0.02,
“accelerometerZMs2”: 0.0
},
{
“$id”: “8”,
“iotSensorMeasuredDateTime”: “2023-06-20T14:25:36.826”,
“accelerometerXMs2”: -0.95,
“accelerometerYMs2”: 0.0,
“accelerometerZMs2”: -0.02
},