JSON discovery returns the value I wnat

[G0nz0uk]

Hello,

I have this test .json file I'm hosting before I get the real data, but each device will look like this:

[
  {
    "name": "A2-Mars",
    "format": "A2",
    "estate": "xyz",
    "location": "Mars",
    "metrics": {
      "pod_screen_percentage_unchanged": 1,
      "pod_screen_percentage_predominant_colour": 17,
      "pod_screen_percentage_desktop": 0,
      "pod_screen_percentage_black": 47,
      "pod_screen_unexpected_size": 0,
      "pod_screen_layout_changed": 0,
      "pod_screen_layout_mismatch": 0,
      "pod_screen_is_monitor_off": 0,
      "pod_broadsign_is_contactable": 1
    }
  },
  {
    "name": "A3-Venus",
    "format": "A3",
    "estate": "xyz",
    "location": "Venus",
    "metrics": {
      "pod_screen_percentage_unchanged": 1,
      "pod_screen_percentage_predominant_colour": 17,
      "pod_screen_percentage_desktop": 0,
      "pod_screen_percentage_black": 34,
      "pod_screen_unexpected_size": 0,
      "pod_screen_layout_changed": 0,
      "pod_screen_layout_mismatch": 0,
      "pod_screen_is_monitor_off": 0,
      "pod_broadsign_is_contactable": 1
    }
  }
]

I basically want to create some graphs for "pod_screen_percentage_black" and also triggers when over 60 for 20mins.

I'm created the Discovery rule and LLD macros such as

{#NAME}

for

$.name

plus the item prototype which is a dependant item with a key of

metrics.pod_screen_percentage_black[{#NAME}]

In the preprocessing I am using a JSONPath and the parameters are set to text as numerical won't work:

$[?(@.name == '{#NAME}')].metrics.pod_screen_percentage_black

If I test:



If I change to numerical (unsigned) in the item protocol section I get:



Value of type "string" is not suitable for value type "Numeric (unsigned)". Value "[47]"

When I test it though is looks ok:



What am I doing wrong?

Thanks

[cyber]

[47] is not excactly 47, what would suit "intger" or "unsigned"
you can also add "$[?(@.name == '{#NAME}')].metrics.pod_screen_percentage_black.first()"

[G0nz0uk]

So is that Zabbix adding the [ ] around the number making it more of a text reply then?

[cyber]

Zabbix shows you everything as requested...
look on examples...

https://www.zabbix.com/documentation/7.0/en/manual/config/items/preprocessing/jsonpath_functionality

It is all something objects vs arrays ... All of it usually makes my head ache..

[G0nz0uk]

Thanks for the URL and example .first() as this worked as numeric (unsigned)

"$[?(@.name == '{#NAME}')].metrics.pod_screen_percentage_black.first()"