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

Example
outputVariable = TableLookup("<tableName>", {})
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
| Table Name | string | Yes | Name of the table to look up in. | |
| Key Values | object | Yes | Key column values to match (e.g., {"funder": "Lex", "type": "BCH"}). |
Outputs
| Name | Type | Description |
|---|---|---|
| outputVariable | json | Stores the matched row as an object, or null if not found. |