Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt
hiddentrue

jsonToItems (JSON, JSON Path, Lenient) Converts JSON to attribute items. Converts a block of JSON data into a recordset which contains the attributes for each node. 


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)

ArgumentTypeDescription
JSON StringStringJSON string to be converted to recordset.
JSON PathString

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.

Lenientboolean

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

...