Lookup Tables

Lookup tables allow recipes to efficiently store, reference, and manage commonly used data in a tabular format with entry rows and value columns, similar to a cross-reference table.

The Lookup Tables page lets you manually create, update, delete, and parse tables.

The Lookup Tables connector lets you build recipes that create, update, delete, and retrieve entry rows, or delete entire tables.F

/

Figure:

Note:

Lookup tables have the following limitations:

• Maximum of 10 columns per table.

• Up to 100,000 entries per table.

  • The Get all entries action retrieves only the first 10,000 entries.

  • Tables with more than 50,000 entries cannot be downloaded as a CSV file.

  • When using Recipe Lifecycle Management, only 10,000 entries can be exported or imported.

To create a new Lookup Table, perform the following steps:

• Navigate to Integration Hub > Users > Tools > Lookup Tables.

• Click + New table.

• Click the Edit (pencil) icon, enter a name for the Lookup Table, and click ✓ Save icon.

• Perform one of the following:

  1. Click Import CSV to upload a CSV file with a header row that defines the column names and table structure.

  2. Click Add entries manually to enter data directly into the table.

  3. Click ✓ Save to save the Lookup Table.

  Figure:

To Add and Update Lookup Table Data:

You can Add or Update entries in a Lookup Table using one of the following methods:

• Import a CSV file

• Add entries manually, one at a time

• Use a recipe action to programmatically insert or update data

Import a CSV file:

To import a CSV file into a Lookup table, perform the following steps:

1. Navigate to Tools > Lookup Tables and click + New table.

2. Click Import CSV.

3. In the Specify action section, select one of the following options:

   1. Add row entries: Adds the CSV rows as new entries. Existing entries remain unchanged.

   2. Replace existing data: Overwrites existing entries with the data from the uploaded CSV file.

   \

   Figure

4. Drag and drop a CSV file into the Select CSV file field, or click Upload from device and select a CSV file.

5. Select the Do not import the first row (header) checkbox if the first row of the file should be excluded from the import.

6. Click Import CSV to complete the upload.

Add or edit entries manually:

1. Click Add entry.

2. Enter values in each column of the new row.

3. Click ✓ Save to save the entry.

   /

   Figure:

Use Recipe Actions:

To automatically add and update entries, use the Add entry, Add entries, and Update entry recipe actions from the Lookup Tables.

The Lookup Tables connector lets you interact with Lookup tables through the following recipe actions:

• Add entry

• Add entries

• Lookup entry

• Search entries

• Get all entries

• Update entry

• Delete entry

• Delete multiple entries

• Truncate table