Parsing nested json array as a single line

[diogomatsubara]

Hi there,

I'm trying to use the infinity plugin to build a dashboard with a table panel containing the information returned by the Github REST API self hosted runners endpoint: https://docs.github.com/en/rest/actions/self-hosted-runners?apiVersion=2022-11-28#list-self-hosted-runners-for-an-organization

The response is in the following format:

{
  "total_count": 2,
  "runners": [
    {
      "id": 23,
      "name": "linux_runner",
      "os": "linux",
      "status": "online",
      "busy": true,
      "labels": [
        {
          "id": 5,
          "name": "self-hosted",
          "type": "read-only"
        },
        {
          "id": 7,
          "name": "X64",
          "type": "read-only"
        },
        {
          "id": 11,
          "name": "Linux",
          "type": "read-only"
        }
      ]
    },
    {
      "id": 24,
      "name": "mac_runner",
      "os": "macos",
      "status": "offline",
      "busy": false,
      "labels": [
        {
          "id": 5,
          "name": "self-hosted",
          "type": "read-only"
        },
        {
          "id": 7,
          "name": "X64",
          "type": "read-only"
        },
        {
          "id": 20,
          "name": "macOS",
          "type": "read-only"
        },
        {
          "id": 21,
          "name": "no-gpu",
          "type": "custom"
        }
      ]
    }
  ]
}

I can't get the right way, with the Default backend or the UQL one, to display the data in a table panel where the labels are expanded into a single row, only with the label name.

I'd like to get the result in the following format:

Name            | Status | Busy | OS         | Labels
linux_runner | online  | true   | linux      | self-hosted, X64, Linux
mac_runner  | online  | false  | macOS | self-hosted, X64, macOS, no-gpu

I tried using JSONPath without success and with UQL I manage to expand the labels array into their own rows, but not all labels of given runner into a single row.

parse-json
| scope "runners"
| mv-expand "label"="labels"
| project "Name"="name", "Status"="status", "Busy"="busy", "OS"="os", "ID"="id", "Labels"="label.name"

Is this possible to do?

[diogomatsubara]

@yesoreyeram Would you be able to help?

[yesoreyeram]

Have you tried backend parser with JSONata? Much easier to achieve what you trying. Give a try and let us know if you still struggle.

[diogomatsubara]

Thanks @yesoreyeram ! This is what I was looking for! One thing though, the results in the table are always alphabetically ordered.

For example, I'm using:

$.runners.{
 "Name": name,
 "Status": status,
 "Busy": busy,
 "OS": os,
 "Labels": $join(labels.name, ", ")
}

and I get the correct data back but the table headers are always ordered alphabetically (e.g. starts with Busy,Labels,Name,OS,Status) as per the attached image.

Is there any way to order the results in the table in the way I specify?

[yesoreyeram]

Use transformation organize fields

[diogomatsubara]

Perfect, thank you!