LLD / JSON / TRIGGER

[HeadQuaker]

Hello,

I Have a script that return that JSON

{
"data": [
{
"DC": "DC1",
"LASTSYNC": "09/07/2021 10:10:35",
"LASTSYNCRESULT": "0"
},
{
"DC": "DC2",
"LASTSYNC": "09/07/2021 10:03:28",
"LASTSYNCRESULT": "0"
},
{
"DC": "DC3",
"LASTSYNC": "09/07/2021 09:58:45",
"LASTSYNCRESULT": "0"
},
{
"DC": "DC4",
"LASTSYNC": "09/07/2021 10:01:36",
"LASTSYNCRESULT": "0"
},
{
"DC": "DC5",
"LASTSYNC": "09/07/2021 10:12:46",
"LASTSYNCRESULT": "0"
},
{
"DC": "DC6",
"LASTSYNC": "09/07/2021 10:12:57",
"LASTSYNCRESULT": "0"
}
]
}
I can have that format too, i do not know which one i should use.
{
"data":[
{"{#DC}":"DC1",
"{#LASTSYNC}":"09/07/2021 10:40:35",
"{#LASTSYNCRESULT}":"0"},
{"{#DC}":"DC2",
"{#LASTSYNC}":"09/07/2021 10:48:27",
"{#LASTSYNCRESULT}":"0"},
{"{#DC}":"DC3",
"{#LASTSYNC}":"09/07/2021 10:43:45",
"{#LASTSYNCRESULT}":"0"},
{"{#DC}":"DC4",
"{#LASTSYNC}":"09/07/2021 10:46:36",
"{#LASTSYNCRESULT}":"0"},
{"{#DC}":"DC5",
"{#LASTSYNC}":"09/07/2021 10:48:40",
"{#LASTSYNCRESULT}":"0"},
{"{#DC}":"DC6",
"{#LASTSYNC}":"09/07/2021 10:48:43",
"{#LASTSYNCRESULT}":"0"}
]
}


What should i do to have a trigger that check is the LASTSYNCRESULT <> 0 for each DC, so i mean it should be in LDD ?


Regards

[HeadQuaker]

Hello thanks, I have got that error, the same i had when i tried. :

Preprocessing failed for: {
1. Failed: cannot extract value from json by path "$.data": cannot parse as a valid JSON object: invalid object name at: ''

Into last values i have only { showing.

Maybe my json is not well generated (come from powershell script)

[HeadQuaker]

hum that's strange so, which one ? the first or the 2nd
how do you try with my json ?
Can you share a command to be sure i am doing it right ?

[HeadQuaker]

hum maybe it does not work because it comes from a windows server because i did the same thing.
Data are sent to the zabbix server but it seems that it could not read them.

[HeadQuaker]

That's strange because the file is really simple

[HeadQuaker]

I have made it in one line, i have the same issue.

[HeadQuaker]

hum always a loss of time with zabbix
There is nothing on their site which can help.

To be clear :
Data are coming into the item BUT it seems that the next step is failing.

[HeadQuaker]

Ok i have managed to make a readable json but now, it seems that the trigger is not working despite the fact the value is in error.

[HeadQuaker]

It's working really thanks to you
I've passed the json using the file directly thru the send.
I am understanding the process better now.