Lookup

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

Result Column values from the matched records.

Example

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.