Parse JSON array

[stefan_eggersto]

Hi all, is it possible in DQL to parse a JSON string that contains an array on the top level?
I can parse a top-level JSON object like 

data record(value = "{\"hello\" : \"world\"}")
| parse value, "JSON:json"

But I fail to parse a top-level JSON array:

data record(value = "[{\"hello\" : \"world\"}]")
| parse value, "JSON:json"

[educampver · Accepted solution]

Hi Stefan, you have to use JSON_ARRAY for that:

data record(value = "[{\"hello\" : \"world\"}]")
| parse value, "JSON_ARRAY:greeting"
| fields greeting