VDRs - How to Filter without Writing JavaScript

Virtual data resources support path level filtering via JSON Path, which is an alternative to using JavaScript for field-level filtering. As an example, the JSON Path expression below will only return the city for the address object in the array if defaultBilling on that object is true.

addressbookList.addressbook[?(@.defaultBilling==true)].addressbookAddress.city

Notable differences

A typical JSON Path expression is prefixed with $. However, when using JSON Path on Cloud Elements, there is no need to prefix the expression.

By default, JSON Path raises an exception when the field cannot be found.  In the example above, an exception would be raised if there was not a city field on the address object. Instead of returning an error, Cloud Elements will return null, which will be removed from the response by default.

Helpful resources

JSON Path documentation - https://github.com/json-path/JsonPath

JSON Path evaluator - https://jsonpath.com/