How to parse json array of strings.

Summary:

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.

Content (required):

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[0]

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):