a!jsonPath() Function

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


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.




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.

Open in Github Built: Thu, Oct 14, 2021 (02:44:34 PM)

On This Page