I'm making an API request with Zabbix here :

{
     "result": "success",
     "maxTotal": 2,
     "users": [
         {
             "unit": "2025-04-01",
             "total": 2
         },
         {
             "unit": "2025-04-02",
             "total": 3
         }
     ]
 }

I want to sum all “total” values (2+3 = 5), I can't find the right syntax.

$.users[*].total.sum()
$.sum($.users[*].total)
$.sum($.users[0].total,$.users[1].total)
...

This does not work, can you help me please :) Thanks

I'm making an API request with Zabbix here :

{
     "result": "success",
     "maxTotal": 2,
     "users": [
         {
             "unit": "2025-04-01",
             "total": 2
         },
         {
             "unit": "2025-04-02",
             "total": 3
         }
     ]
 }

I want to sum all “total” values (2+3 = 5), I can't find the right syntax.

$.users[*].total.sum()
$.sum($.users[*].total)
$.sum($.users[0].total,$.users[1].total)
...

This does not work, can you help me please :) Thanks

• jsonpath

• In which programming environment are you using JSONPath? As far as I know sum is not part of JSONPath specs itself. – trincot Commented yesterday
• This seems to be implemented zabbix/documentation/6.0/en/manual/config/items/… – user30154581 Commented 4 hours ago

1 Answer 1

In javascript?

I'm not quite an expert but, if you set up a while loop:

totals:int = 0;
for(i=0;i<return[...].users.lenght;i++){
 totals = total + return.users[i].total;
}

Not working?