I have created 1 JSONPath which is working fine on https://jsonpath.com/ But I'm configuring in JSON Path expression, it is giving me error :
JSON Path expression assertion failed
Not sure in which format Site 24X7 is accepting below JSON Path :
$.environments[*].dimensions[?(@.name=="SFAPI,NAD_DIGITAL")].metrics[?(@.values > 40)]
Sample JSON :
{
"environments": [
{
"dimensions": [
{
"metrics": [
{
"name": "sum(message_count)",
"values": [
"35.0"
]
}
],
"name": "SFAPI,NAD_SF"
},
{
"metrics": [
{
"name": "sum(message_count)",
"values": [
"44.0"
]
}
],
"name": "SFAPI,NAD_DIGITAL"
}
],
"name": "nad-prod12FFFHHF"
}
],
"metaData": {
"errors": [],
"notices": [
"Table used: uap",
"Source:BB",
"query served by:job_1234"
]
}
}