How to extract and filter from nested JSON one field

Grafana Dashboards
1

Hi everyone,

I have configured Infinity Data Source that returns JSON response as per below:

[
  {
    "id": 0,
    "field1level0": "value",
    "array1level0": [
        {
            "id": 0,
            "field1level1": "value",
            "array1level1": [
                {
                    "id": 0,
                    "field1level2": "value",
                    "successful": true
                }
            ],
            "successful": false
        }, many more fields on level1
    ]
  }, many more fields on level 0
]

I want to create dashboard that will look as follows:
Column1: fields from level0 as field0
Column2: fields from level1 as field1 but only those fields where fieldXlevel1 is equal to “valueX”
Column3: fields from level1 as successful

So far I managed to list all values of fields in level1 in rows but I want to list only specific ones.

parse-json
| mv-expand "temp"="array1level0"
| project "field0"="field1level0", "field1"="temp.field1level1", "field2"="temp.successful"

The only difference I want to achieve, is to have only specific value for field1, in other words, there are no multiple rows for field0.

Does anyone how can I achieve it?