Skip to main content

Table Lookup

Looks up a single row by exact key match. Returns the matched row or null.

Category: Named Tables & Rules Engine · Group: Tables · Activity name: TableLookup

The TableLookup activity in the designer

Example

outputVariable = TableLookup("<tableName>", {})

Inputs

NameTypeRequiredDefaultDescription
Table NamestringYesName of the table to look up in.
Key ValuesobjectYesKey column values to match (e.g., {"funder": "Lex", "type": "BCH"}).

Outputs

NameTypeDescription
outputVariablejsonStores the matched row as an object, or null if not found.