Expression | The JSONata expression to be used to filter the input data. These are some examples: Accessing a particular value from JSON object: e.g. Account.Order[0].OrderID. The above expression gets the OrderID value from the first item of the Orders list. Account is JSON object, Order is JSON array and OrderID is the key. Numeric functions can be used such as $number(), $abs(), $floor(), $ceil(), $round(), $sq rt(). Aggregation functions can also be used: $sum(), $max(), $min(), $average(). Sorting functions can sort the data based on one or more attributes. The example below sorts an array of beer styles based on the updateDate attribute. e.g. $sort(data.style, function($l, $r) { $l.updateDate < $r.updateDate }).
|