Hi, struggling trying to count objects in a big json doc. I'm on version 8.0.5, so function json_keys is not available.
{
"0": {
"field1": "123"
},
"1": {
"field2": "123"
},
"2": {
"field3": "123"
},
"3": {
"field4": "123"
},
"4": {
"field5": "123"
}
}
This is a sample, I am able to get down to the path (startpath) with spath. What I'm trying to do is count the instances of the objects (0,1,2,3,4). I can't cleanly regex backwards as the real values names are not consistent. Thought I could do something like startpath{} and list them out , but the wildcards {} are not working anyway I try it. Thoughts, suggestions?
Thanks
Chris
... View more