This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
we have the number of rows divided by 1 min each
“2023-04-01 12:00:00 UTC”
“2023-04-01 12:01:00 UTC”
“2023-04-01 12:02:00 UTC”
“2023-04-01 12:03:00 UTC”
“2023-04-01 12:04:00 UTC”
“2023-04-01 12:05:00 UTC”
“2023-04-01 12:06:00 UTC”
“2023-04-01 12:07:...
I am trying to parse the below JSON in the JSON generator snap but getting the error.
Error: Expecting array for JSON-Path array index, found: Map
Payload :
[
{
“AccountId”: “9999”,
“FeatureName”: "test json -->>"$[0].UserIds[0]" test end "
}
]
I...
How can we get the max element of the array with its corresponding index?
Ex : “somefield” : [1,2,2,2,2,1,1,1,1]
Max element is 2 and indexes are 1,2,3,4
Hey @viktor_n ,
Actually, the problem is that “$[0].UserIds[0]” is not the value that I am trying to get from the pipeline, but it’s the text itself that is supposed to have $ signed value in it.
(its the Mysql query which allows querying JSON data b...
