Expand JSON Data from Microsoft Graph API in Grafana Infinity (UQL)

[trylvis]

I am using the Infinity plugin in Grafana to fetch Azure Entra ID Application Registrations via Microsoft Graph API. My goal is to display all secrets ( under "passwordCredentials" ) and their expiration dates in Grafana. However, I am encountering challenges accessing the nested value array and properly expanding the data using UQL.

API Response
I am querying Microsoft Graph API:

https://graph.microsoft.com/v1.0/applications?$select=displayName,passwordCredentials

Getting this output:

{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#applications(displayName,passwordCredentials)",
  "value": [
    {
      "displayName": "App Reg 1",
      "passwordCredentials": [
        {
          "displayName": "mysecret",
          "endDateTime": "2025-04-16T17:01:53.448Z",
          "hint": "bHb"
        },
        {
          "displayName": "mysecret2",
          "endDateTime": "2025-05-23T14:51:02.4Z",
          "hint": "agd"
        }
      ]
    },
    {
      "displayName": "Grafana Cloud Connector",
      "passwordCredentials": [
        {
          "displayName": "abc123",
          "endDateTime": "2026-11-27T13:54:51.094Z",
          "hint": "UkI"
        }
      ]
    },
    {
      "displayName": "My App Reg 3",
      "passwordCredentials": []
    }
  ]
}

Attempting queries like:

parse-json
| mv-expand result.value

results in "error applying uql query".

project kv() 

returns as shown on the image, with "object, object" for the value.

How can I process this correctly? Thanks!

[yesoreyeram]

I suggest trying with backend parser and JSONata syntax in the root selector. That is pretty convenient and powerful.

but still if you prefer UQL, https://grafana.com/docs/plugins/yesoreyeram-infinity-datasource/latest/query/uql/ have more documentaion

[Nastya-1440]

@yesoreyeram , hi!
Can u help me?)
Format Time series ws Format Table. Format Time series visualizes incorrect data, why? But table works correct.

[yesoreyeram]

I don't see anything wrong. Looks like the chet aligned with the dashboard time range.isn't it?

[Nastya-1440]

I thought, the values were in ascending order in my Json. Thank u ;)