I need help with JSONPath filter

[kloczek]

My input json looks like below:

[
  {
    "name": "foo",
    "value": "value1"
  },
  {
    "name": "bar",
    "value": "value2"
  }
]

I need to extract value when name="bar"
I'm trying to use as the JSONPath filter:

$[?(@.name=='bar')].value

and because it does not work looks like syntax of my filter is wrong.
Someone can help?

Other thing is that looks like now zabbix 4.2.x does not provides anything like test page for testing filters with some inputs and any problems with filters are not reported in logs.
Is it anywhere complete documentation of the JSONPath syntax used by zabbix?
Looks like it is different than that one used for example by jq.

[kloczek]

After many experiments I found so far only working JSONPath expression which is:

$.[?(@.name=="bar")].setting

Issue is that exactly filter returns

["bar"]

and I want just:

"bar"

[brunohl]

Hey,

As it said here the JSON Path's result is always an array. (https://goessner.net/articles/JsonPath/)
But in my usage Zabbix transforms it into a string as a value result.

+1 to the pre-processing tester.
I've found this tester online btw https://jsonpath.curiousconcept.com/

[kloczek]

Hmm .. I think that I'll end up with stacked another filter to strip those []

[user185953]

Problem with JSONpath filters is they can match more things than one.

Zabbix solution since 4.0.11:

$.[?(@.name=="bar")].setting.first()

See full documentation: https://www.zabbix.com/documentation...npath#overview