How to parse json array of strings.
I've been working JSON tables and querying them. I've just run across a data structure that I cannot figure out how to parse.
The json array looks like this:
"listOfIds" : [ "id1", "id2"]
The lists can contain 1 or more ids. How do I parse this to get separate rows for each id? I can get the first id like this:
"IDS" PATH $.listOfIds
When I try this:
"IDS" PATH $.listOfIds[*]
I get the id when there is only one. But I get null when there is more than one.
Version (include the version you are using, if applicable):