Json request via url with infinity plugin

Grafana Configuration
1

Hi there im trying to integrate Acronis Cyber protect platform reports to grafana via json call.
the command is

GET /api/am/api/1/playbook/call/summary_alert_table?from=$last_30_days&limit=10&utc=2

And returns values but in one line with pointer data

[{“activity_type”:“infrastructure”,“resource_name”:…}]

or

{
“series”: [
{
“data”: [
{
“activity_type”: “infrastructure”,
“resource_name”: “genper”,
“resource_type”: “machine”,
“severity”: “warning”,
…
}

If i take it with inline method and remove these pointer works
{
“series”: [
{
“data”:

But this makes the report static and not refreshable

could you please advise?

2

I would also try this similar plugin and see if you have more luck destructuring the data: