Infinity Datasource - Json Parse

Grafana Dashboards
1

I’m using UQL with infinity datasource to create a 4 column table -

“ID”, “Submitter”, “Date”, “Server”

From “values”, I get the columns “ID”, “Submitter”, “Date” with query:

parse-json
| project "entries"
| project "values.ID","values.Date","values.Status"

Seperately, from “_embedded”, I can get the columns “Server” with query:

parse-json
| project "entries"
| project "_embedded.assoc-CHG:Association"

But, I can’t join them altogether, in one 4 column table.

How do I update my UQL query to achieve this?

My JSON is as follow:

{
    "entries": [
        {
            "values": {
                "ID": "BRQ00077077",
                "Submitter": "John Doe,
                "Date": "2024-05-15"
            },
            "_embedded": {
                "assoc-CHG:Association": [
                    {
                        "values": {
                            "Associations ID": "CHA000005234234",
                            "Server": "lrr2jbs8742.example.int"
                        },
                    },
                    }
                ]
            }
        }
    ],
2

image
image1434×1109 66.9 KB

1 Like
3

Thank you for the response.

I can return the values “ID”, “Submitter”, “Date”.

But, I cannot return the value “Server” as a column.

I have multiple values for “server” for each record in my JSON.

I’ve tried “_embedded.assoc-CHG:Association.values.Server”, as you suggested

But, it didn’t return the values.

{
    "entries": [
        {
            "values": {
                "ID": "BRQ00077077",
                "Submitter": "John Doe,
                "Date": "2024-05-15"
            },
            "_embedded": {
                "assoc-CHG:Association": [
                    {
                        "values": {
                            "Associations ID": "CHA000005234234",
                            "Server": "lrr2jbs8742.example.int"
                        },
                    },
					{
                        "values": {
                            "Associations ID": "CHA0000544444",
                            "Server": "lrr2jbs9998.example.int"
                        },
                    },
					{
                        "values": {
                            "Associations ID": "CHA00000567567",
                            "Server": "lrr2jbs8877.example.int"
                        },
                    },
                    }
                ]
            }
        }
    ],
4

that is an invalid json data, please correct and repost? using jsonata

https://try.jsonata.org/pCmmCy7va

image
image1704×708 66.7 KB