Expressions - cheatsheet
wants to help you build solutions quickly and easily. To help you do this, here is a list of functionality or data results you might want to use in your app with the expression used to achieve it. This is a starting point; you can adapt or add to the expression as needed to get the expected data results when building solutions. Refer to the Expressions section in the Examples tab for working examples and code snippets for various JSONata expressions.
See tips and tricks when using placeholders for additional information.
Results can include id, email, name.
This example with data and the result can be viewed in JSONata exerciser.
This example with data and the result can be viewed in JSONata exerciser.
converts @ctx. to $$. when executing expressions in jsonata
To update multiple records using the Execute-entities action, you can use the expression below.
See the examples provided in Regex expressions.
See more examples provided in JavaScript expressions.
Checks for undefined, false, empty string, empty objects, null, empty array, and boolean false. It is better than using (jsonataTruthy) or $empty or $exist in JSONata as it checks for all scenarios and returns false in a single function, whereas using a combination of JSONata functions is necessary to return false.