Working with JSON object/blob

Grafana Dashboards
1

Hello! I’ve been trying to work on parsing a returned JSON object without much success. Based on Infinity’s “golden rule of thumb”, my data needs to be an array of objects. If it’s not, it recommends using UQL. So here I am, trying to process my data using UQL also without much success. I’d appreciate any help I can get to get my parsing to work.

My (simplified) data:

{
  "id": 2222,
  "timestamp": "2025-02-09",
  "dependencies": {
    "builds": [
      {
        "name": "foo",
        "status": "SUCCESS"
      },
      {
        "name": "bar",
        "status": "FAILURE"
      }
    ]
  }
}

The visualization I am aiming for:

image
image1150×181 9.82 KB

  • Because I still need access to id and timestamp, I can’t scope down to builds
  • I can’t seem to extend on a root object, otherwise I would have done something like:
parse-json
| extend "foo"=pack('ID',"id",'dependencies',"dependencies.builds")
| project "foo"

or

parse-json
| extend "dependencies"="dependencies.builds"
...

How would you approach it?

2

Hi,

I’m not much of UQL fan, I’d rather do with jsonata and backend parser. I think something like this would work for your case:

$merge([{"id": id, "timestamp": timestamp}, $merge(dependencies.builds.{name: status})])

(although it doesn’t preserve the key order, at least in Grafana)

3

Hi Dawid, thanks for you assistance here. That looks very much like what I am aiming for. Would you mind helping me the final step? It looks like the returned object is not properly being visualized: Grafana

On a side note, I am quite new to Grafana. Having to read up on Grafana, the Infinity plugin, UQL and now JSONata just to render a simple JSON object just isn’t very beginner friendly. I’ll spend some more time with JSONata as it looks powerful enough to do things I will need going forward.

4

Actually never mind, it seems running JSONata for the backend parser is possible, just that I didn’t see it. It’s provided in the “Rows/Root - optional” box in the Parsing options drawer.

https://play.grafana.org/goto/kUAt4wKHR?orgId=1

For some reason returning a single JSON object from UQL doesn’t correctly process it. I’ll see if I can report this.