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\"}")<br>| parse value, "JSON:json"

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

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

[educampver]

Hi Stefan, you have to use JSON_ARRAY for that:

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