Infinity - how to set default variable value or mask unsuccessful infinity query

Grafana Dashboards
1

Grafana v11.1.0 (Ubuntu 24.04), Infinity plugin v3.0.0-beta.1

Grafana newbie here… I’m trying to populate a dashboard table with some information from multiple REST API endpoints using infinity, and not having much luck.

I make a call to one endpoint ./api/objectCatagory and get back a json array like this:-

{
    "objectCatagory": [
        {
            "id": 1234,
            "name": "objectName1",
            "time": "14 Feb 2025 01:50:10 +0000",            
            "info": {
                "title": "ABCD1234_XY",
                "filename": "21dff8da-d257-4c70-96ed-b45f13487ea0.txt"
            }
        },
        {
            "id": 1235,
            "name": "objectName2",
            "time": "14 Feb 2025 01:51:01 +0000",            
            "info": {
                "title": "EFGH5678_YZ",
                "filename": "b45f13487ea-96ed-d259-4c71-021dff8da.txt"
            }
        }
    ]
}

All good, can parse that using the default parser as columns and get a single table. FWIW, I’m using the default parser because if I use ‘Backend’, the time isn’t parsed as ‘Time’ (not matter what optional ‘Time Format’ I use).

Next, I want to use the ‘id’ parsed for each item in the array returned above, and make another call to a slightly different endpoint to get more detailed data. e.g. ./api/objectCatagory/<id>/data
I want to parse that JSON response. e.g.

{
    "data": [
        {
            "id": 1236,
            "name": "task 1",
            "status": "finished",
            "progress": 100,
            "start": "14 Feb 2025 01:56:18 +0000",
        },
        {
            "id": 1237,
            "name": "task 2",
            "status": "in-progress",
            "progress": 69,
            "start": "14 Feb 2025 01:59:33 +0000",
        },
    ]
}

and look in the array, find the element that is ‘in-progress’, and get it’s name and progress value, and add that as a column to my first table.

I came to the conclusion that this simply isn’t possible in Grafana with Infinity and started pursuing alternatives/workarounds.

I’m now creating a query variable (shown on dashboard) that is identical to the first query to return a table consisting of a user friendly name and the id. In the dashboard, the data source is set to be Mixed, and I’ve added my second Infinity data source query, now using the query variable. e.g.

./api/objectCatagory/${query0.dataId}/data

This gets me close… at the bottom of the table there’s an option to select the second data source to show the enhanced data, and the query variable at the top can be used to select the enhanced data to see.

One problem, the second call may result in a ‘unsuccessful response’ error if ${query0.dataId} is empty. Is there a way I can hide the error icon shown on the dashboard, or if query0 (query0.dataId to be precise) is empty, substitute it’s value with a default ID?

(FWIW… I’ll see if I can add a transform to try and achieve the original goal).