Parse JSON array

stefan_eggersto — Wed, 31 May 2023 14:00:58 GMT

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"

Re: Parse JSON array

educampver — Thu, 01 Jun 2023 11:08:32 GMT

Hi Stefan, you have to use JSON_ARRAY for that:

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