$lookupTable

Signature: $lookupTable(table, filterKeys, filterPredicates[, options])

Parameters:

  • table - Source lookup table. All lookup tables are available inside $tables global variable
  • filterKeys - String or array of strings of keys to filter on
  • filterPredicates - One or more predicates to filter on. If filterKeys is an array, filterPredicates must be an array of the same length
  • options - Object with optional properties:
    • wildcard - Wildcard string to use for matching. E.g. if set to ”*”, then “express_aero” will match “express_*“.

Returns row from a lookup table where all filter conditions are satisfied. Supports wildcard matching. This function is provided by Stedi and isn’t a part of the JSONata standard library.

Example

Given following lookup table named “shipping”:

KeyValuePreferred
1expressfalse
2standardfalse
2overnighttrue
3express_*false
ExpressionResult
{'$lookupTable($tables.shipping, "Key", "1").Value'}"express"
{'$lookupTable($tables.shipping, "Key", "2").Preferred'}["false", "true"]
{'$lookupTable($tables.shipping, ["Key", "Preferred"], ["2", "true"]).Value'}"overnight"
{'$lookupTable($tables.shipping, "Value", "express_aero", { "wildcard": "\*" }).Key'}"3"
{'$lookupTable($tables.shipping, "Value", "express_other", { "wildcard": "\*" }).Key'}"3"

$uuid

Signature: $uuid()

Create a version 4 (random) UUID. This function is provided by Stedi and isn’t a part of the JSONata standard library.

Example

ExpressionResult
$uuid()"1a28e35f-d420-4b95-ad09-1bb4b39821dc"