I’m using Infinity datasource plugin. While trying to define a variable, these problems arise. The rest of the variables are correctly set and working. Is there any known bug with these filters?
If I use Default parser, it doesn’t allow me to choose tierName:
I would recommend you use UQL please share sample csv,json data
please clean it up and post proper json format not of your dashboard but the data you are trying to filter?
{
"type": "Feature",
"id": "SVK",
"properties": {
"name": "Slovakia"
}
}
you have odd “time”: quotation marks and all
Also vet out the validity of the json before posting it like on https://jsonformatter.curiousconcept.com/#?
[
{
"appAgentVersion":"Server Agent abc",
"machineAgentVersion":"Machine Agent abc",
"agentType":"APP_AGENT",
"type":"Other",
"machineName":"abc",
"appAgentPresent":true,
"nodeUniqueLocalId":"",
"machineId":111,
"machineOSType":"Linux",
"tierId":111,
"tierName":"aaa",
"machineAgentPresent":true,
"name":"aaa",
"ipAddresses":null,
"id":111
},
{
"appAgentVersion":"Server Agent abc",
"machineAgentVersion":"Machine Agent abc",
"agentType":"APP_AGENT",
"type":"Other",
"machineName":"abc",
"appAgentPresent":true,
"nodeUniqueLocalId":"",
"machineId":111,
"machineOSType":"Linux",
"tierId":111,
"tierName":"aaa",
"machineAgentPresent":true,
"name":"aaa",
"ipAddresses":null,
"id":111
}
]
using UQL
parse-json
| where "tierName" == '${tiers}'
is this a variable?
Yes, it is. And the data comes from an HTTP GET request.
which data point do you want returned from the json data?
parse-json
| jsonata "($muzak := $filter($, function($v, $i, $a) {$v.tierName = '${tiers}' }); $muzak.machineName)"
play around with it
It worked! Thanks a lot!