Why JSONPath is not recognized and how to resolve it

Learn more about the difference between the JSONPath expressions used in connectors and in the Execution panel of the Digibee Integration Platform.

JSONPath is a set of expressions that are used to query values in a JSON object. You can use the expressions to navigate through a JSON and retrieve elements, nested elements, and arrays.

On the Digibee Integration Platform, you can use JSONPath on some specific connectors, such as in the JSON Path Transformer, in Double Braces expressions using the JSONPATH() function, or to search for information in the Execution panel.

We currently use two JSONPath libraries:

• For connectors and the JSONPATH() function we use the Jayway JsonPath library.

• For the Execution panel we use the JSONPath Plus library.

For example, you can use the following expression for connectors and the JSONPATH() function:

$.body.data[0].attributes.columns[1].values[?(@.length()==1)]..*

And for the Execution panel, you can use the following expression:

$.body.data[0].attributes.columns[1].values[?(@.length==1)]..*

Please read the documentation of each library to understand how to create JSONPath expressions:

• Jayway JsonPath

• JSONPath Plus