JSONata()

edit

Query and transform JSON data using JSONata expressions. See https://jsonata.org for expression syntax.

Requires Extension: JSONata Extension

JSONata( expression=string, data=any, bindings=struct, options=struct );

Returns: any

Argument Description
expression
string, required 		edit

JSONata expression string. Examples: "$sum(c)", "$.name", "orders[status='complete']", "{ 'total': $sum(items.price) }"
data
any, required 		edit

JSON data to query - can be a struct, array, or JSON string.
bindings
struct, optional 		edit

Optional struct of variable bindings accessible in the expression. Example: { maxPrice: 100 } makes $maxPrice available.
options
struct, optional 		edit

Optional struct with runtime options. Supported keys: timeout (milliseconds, default 5000), maxDepth (recursion limit, default 100), functions (struct of closures/UDFs to register as custom $functions).

Examples

There are currently no examples for this function 33,423ms WARN No examples for function JSONata

See also