In Operator Support for JSON API DataSource

Grafana Dashboards
,
1

Hi Team

We have a requirement where we want to filter data in dashboard and as a datasource we’re using JSON API, in filter we want to provide multi-value filter support and based on that we want to filter data of our JSON API.

API response {
“items” : [
“name” :“test”,
“arr”:[
“a”:1,
“b”:2
]
]
}

Here i want to use name in dashboard filter and it can be multiselect and based on that i want to filter my json data which i am visualising in table view.

as here we need “IN” operator support , from documentation we didnt have any support .

Thanks

2

Please post a valid json that has been validated for example via https://jsonlint.com/

3 
{
	"items": [{
		"name": "test",
		"arr": [{
			"a": 1,
			"b": 2
		}]
	}, {
		"name": "test1",
		"arr": [{
			"a": 2,
			"b": 3
		}]
	}]
}

@yosiasz added here

1 Like
4

Recommend using infinity plugin

parse-json
| scope "items"
| jsonata "* [name in [${test:singlequote}]][]"

image
image1073×618 27.2 KB

5

@yosiasz , can we add scope on “arr” field and put jsonata filter on name?

6

@subodh2711 - I think you need mv-expand operator. More details https://yesoreyeram.github.io/grafana-infinity-datasource/wiki/uql/

parse-json
| scope "items"
| mv-expand "arrItem"="arr"
| jsonata "* [name in [${test:singlequote}]][]"
1 Like
7

Screenshot 2022-07-12 at 4.18.14 PM
Screenshot 2022-07-12 at 4.18.14 PM2447×1721 173 KB

@yesoreyeram , its coming as in json format can we split and show and explicitly. and what about if we have an array inside arr again can we define scope on nested array and go inside that.

8

adding

| project "name", "a"="arrItem.a", "b"="arrItem.b"

at the end of the UQL query will help.

1 Like
9

Thanks , i tried it helps