Want to show json data row by row. But it is showing single row

HI Team,

We are trying to show values as table format based on JSON. We are getting all the values in same row but we are expecting row by row values. Could you please suggest how to solve that issue.

Json Data:

[
	{
		"result": "succeeded",
		"name": "Initialize job",
		"state": "completed"
	},
	{
		"result": "succeeded",
		"name": "Checkout gitleaks-config@main to s/gitleaks-config",
		"state": "completed"
	},
	{
		"result": "succeeded",
		"name": "Checkout 14819-CD-ansible-testing@release/metrics-test to s/14819-CD-ansible-testing",
		"state": "completed"
	},
	{
		"result": "succeeded",
		"name": "Finalize Job",
		"state": "completed"
	}
]

Table Showing same row:

Grafana version : v9.1.0

  • What happened?
    It is showing same row all the values fron json data.

  • What did you expect to happen?
    It should be showed row by row

JSON Data you provided is processed correctly by Infinity plugin:

Thanks ebabeshko.
As of now we using open search data source so how can i pass that values to infinity plugin which i received from open search
Currently I am using Grafana version : v9.1.0 so this version support Infinity plugin.

is open search endpoint url:9200?

No,we are using ***es.amazonaws.com.

provide that endpoint to the infinity plugin, the Source URL section

image

Thanks @yosiasz

Another query is “We are using opensearch datasource so we need to display array of objects in pie chart.”

Sample :

Names : [{
“userone”: 3
},
{
“usertwo”:2
},
{
“userone”: 2
}]

we are expecting output like this

Name Count
userone 5
usertwo 2

NOTE: I already raised this query separate but i haven’t got any response “How to display array of objects in bar or pie chart for opensearch datasource