Other functions

$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”:

Key	Value	Preferred
1	express	false
2	standard	false
2	overnight	true
3	express_*	false

Expression	Result
{'$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

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