JSONParse - JSONPath help

[tbrahmer]

I am receiving a json response formatted exactly in this manner:

Code: Select all

[{"usr_uid":"000","usr_name":"admin"},{"usr_uid":"127","usr_name":"bot"},{"usr_uid":"269","usr_name":"fred"}]

I can't seem to find the proper way to reference the nodes in this structure via the JSONParse command. I've checked the online validators and they say it is valid JSON and I am able to reference nodes properly using those online validators. For instance $[0].usr_name returns "admin", $[1].usr_uid returns "127", etc. The '$' character is supposed to represent the 'root' of the structure.

However, I am unable to get the JSONParse command to properly reference the array elements when they are directly at the root level like this. Using similar notation in Macro Scheduler ( $[X].objname ) isn't returning any match. Any ideas?

Thank you very much for any help you can give me!

[Marcus Tettmar]

That's a JSON array but not a JSON object. It's only part of a JSON object. The array has no name.

If you give it a name we can reference it:

Code: Select all

/*
JSON:
{"things":[{"usr_uid":"000","usr_name":"admin"},{"usr_uid":"127","usr_name":"bot"},{"usr_uid":"269","usr_name":"fred"}]}
*/
LabelToVar>JSON,sJSON
JSONParse>sJSON,things[1].usr_uid,res

[tbrahmer]

Thank you Marcus, I see that will work. I will add code to alter that response after I get it and give the array a name like you demonstrated. Thanks for your help!

[pfischer]

Dear Marcus,
I just found this post from some years ago with respet to a json output. However, I really do not get it.

My JSON output is exactly like the output from tbrahmer:

[{"usr_uid":"000","usr_name":"admin"},{"usr_uid":"127","usr_name":"bot"},{"usr_uid":"269","usr_name":"fred"}]

In your reply you recommend to give the array a name and in you give the following code as solution:
/*
JSON:
{"things":[{"usr_uid":"000","usr_name":"admin"},{"usr_uid":"127","usr_name":"bot"},{"usr_uid":"269","usr_name":"fred"}]}
*/
LabelToVar>JSON,sJSON
JSONParse>sJSON,things[1].usr_uid,res

However, the upper lines are commented -> so when I have the string [{"usr_uid":"000","usr_name":"admin"},{"usr_uid":"127","usr_name":"bot"},{"usr_uid":"269","usr_name":"fred"}], how do you give this array a name? as you recommend. It cannot be by the commented code section because this is inactive??

Probably I hav a block in my mind but can you explain how to give the string a name?

Thanks
Phil

[Grovkillen]

LabelToVar takes the commented lines and put them as a variable. So it's perfectly fine that they are commented since you don't want the compiler to act on that part of the code.