a!jsonPath() Function

Finds information in a JSON string. JSONPath is used to navigate through elements and attributes in a JSON string.

Syntax

a!jsonPath( value, expression )

  • value (Text) The JSON text representing the value to be queried.
  • expression (Text) The JSONPath query to be run against the JSON object.

Returns

Text

Notes

The below table defines the syntax for the expression parameter of a!jsonPath().

Expression Description
$ the root object/element
@ the current object/element
. or [] child operator
.. recursive descent
* wildcard. All objects/elements regardless their names.
[] subscript operator
[,] alternate names or array indices as a set.
[start:end:step] array slice operator
?() applies a filter (script) expression
() script expression, using the underlying script engine.

Array indices in JSONPath start with zero, not one.

FEEDBACK