This action queries records, matching to an input record, from the data source.

Action Settings

Setting Description
Table An object to query records from.
Keys The lookup table fields, by which input records and lookup table records are matched.
Result Columns The columns from the matched records, returned as the result.

Action Parameters

Lookup action parameters correspond to the selected Keys.


Result Column values from the matched records.


Here is an example of Lookup action in the Lookup component of Data Flow. This example shows the Lookup action that matches Zoho CRM accounts with the input records by their names and returns the matched Zoho CRM account IDs.

Lookup action in data flow