Function: jsonToItems()

Converts a block of JSON data into a recordset which contains the attributes for each node on the JSON.

Syntax

jsonToItems(JSON String, JSON Path, Lenient)

Argument Type Description

JSON String String JSON string to be converted to recordset.

JSON Path

The JSON Path expression is evaluated against the data provided by the JSON String. It determines which elements are extracted from the JSON.

Defaults to “$” which matches the entire document. This must be passed in as a string i.e. encapsulated in quotes.

Lenient

boolean

Lenient is a flag which determines whether to pass the JSON String leniently. Defaults to false.

Expression	Description
`$`	symbol refers to the root element.
`@`	symbol refers to the current element.
`.`	is the dot-child operator, which is used to denote a child element of the current element.
`[ ]`	is used to select a child element of the current element (by name or index number).
`*`	a wildcard, returning all elements regardless of their name.
^	symbol is used to traverse up 1 element in the JSON hierarchy from child to parent.

Record Set Returned

jsonToItems('{"data":[{"value":"foo"},{"status":"bar"}]}', '$.data', true)

Returns

// returns a record set
{"value" : "foo"}, {  "value" : "bar"}

Array Returned

jsonToItems('{"data":[{"value":"foo"},{"status":"bar"}]}', '$.data', true).value

Returns

// returns an array of values*
[foo, bar]

*The array results can be accessed using normal Array Handling Functions