Parse multiple JSON values

Grafana Dashboards
1

I am using last community version in March, 2025 and I am trying to parse all the values in the arrays data in the answer below from Inflinity plug in.

{
  "/Random/Int1": {
    "request": {
      "tag": "/Random/Int1",
      "start": 1740927000000,
      "end": 1740927060000,
      "options": {
        "remoteNode": null,
        "mode": "raw",
        "method": null,
        "interval": null,
        "deadband": null,
        "invalidAsNull": true,
        "limit": null
      }
    },
    "data": [
      [
        1740927000000,
        119,
        192,
        2
      ],
      [
        1740927002986,
        37,
        192
      ],
      [
        1740927008002,
        57,
        192
      ],
      [
        1740927013020,
        23,
        192
      ],
      [
        1740927018034,
        71,
        192
      ],
      [
        1740927023046,
        92,
        192
      ],
      [
        1740927028064,
        70,
        192
      ],
      [
        1740927033075,
        17,
        192
      ],
      [
        1740927038091,
        43,
        192
      ],
      [
        1740927043107,
        41,
        192
      ],
      [
        1740927048121,
        121,
        192
      ],
      [
        1740927053141,
        95,
        192
      ],
      [
        1740927058155,
        51,
        192
      ]
    ]
  },
  "/Random/Int2": {
    "request": {
      "tag": "/Random/Int2",
      "start": 1740927000000,
      "end": 1740927060000,
      "options": {
        "remoteNode": null,
        "mode": "raw",
        "method": null,
        "interval": null,
        "deadband": null,
        "invalidAsNull": true,
        "limit": null
      }
    },
    "data": [
      [
        1740927000000,
        26580,
        192,
        2
      ],
      [
        1740927002986,
        7897,
        192
      ],
      [
        1740927008002,
        14397,
        192
      ],
      [
        1740927013020,
        25887,
        192
      ],
      [
        1740927018034,
        22599,
        192
      ],
      [
        1740927023046,
        24694,
        192
      ],
      [
        1740927028064,
        3756,
        192
      ],
      [
        1740927033075,
        1798,
        192
      ],
      [
        1740927038091,
        9426,
        192
      ],
      [
        1740927043107,
        13132,
        192
      ],
      [
        1740927048121,
        18918,
        192
      ],
      [
        1740927053141,
        18332,
        192
      ],
      [
        1740927058155,
        31692,
        192
      ]
    ]
  },
  "/Random/Int4": {
    "request": {
      "tag": "/Random/Int4",
      "start": 1740927000000,
      "end": 1740927060000,
      "options": {
        "remoteNode": null,
        "mode": "raw",
        "method": null,
        "interval": null,
        "deadband": null,
        "invalidAsNull": true,
        "limit": null
      }
    },
    "data": [
      [
        1740927000000,
        24588,
        192,
        2
      ],
      [
        1740927002986,
        10502,
        192
      ],
      [
        1740927008002,
        16735,
        192
      ],
      [
        1740927013020,
        10336,
        192
      ],
      [
        1740927018034,
        10962,
        192
      ],
      [
        1740927023046,
        20753,
        192
      ],
      [
        1740927028064,
        89,
        192
      ],
      [
        1740927033075,
        29761,
        192
      ],
      [
        1740927038091,
        10768,
        192
      ],
      [
        1740927043107,
        28726,
        192
      ],
      [
        1740927048121,
        27041,
        192
      ],
      [
        1740927053141,
        25417,
        192
      ],
      [
        1740927058155,
        14269,
        192
      ]
    ]
  }
}

I am able to read individual values directly using for example "/Random/Int1.data.[0][0]’ as a column to parse a timestamp. However, I need all the values in the arrays “data” per tag to build time series trends. I tried to use different resources (JSONata, Columns, UQL), including suggestions from Grot AI, chatGPT, Gemini and Deepseek without success.

infinity_error
infinity_error1937×1125 521 KB

Thank you for your help!

1 Like
2

Welcome @engacosta

Please repost that JSON as a properly fornatted json

3

Hi yosiasz. Thank you for the quick reply.
I edited the original message with the formatted JSON.

4

here is a lead, play around with it so that you can use jsonata to get what you need

https://try.jsonata.org/IWsGP3E_S