Page tree
Skip to end of metadata
Go to start of metadata

Syntax
JSON_ELEMENTS(<string>;N)

Description
Returns the top N elements of a JSON array.

If N is left blank, all elements of the json array will be returned.


Examples:

=JSON_ELEMENTS("[\"a\",\"b\", null]") returns a string array of length 3 containing "a", "b", null
  • No labels

1 Comment

  1. If you get empty results after applying JSON_ELEMENTS on JSON_KEYS results, use function TOJSON on the results of JSON_KEYS before feeding the outcome into JSON_ELEMENTS:

    1.   TOJSON(JSON_KEYS(#ActivityAttributes))
    2. JSON_ELEMENTS(#json_keys)