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. 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.

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:

1. Log in to the Application.
   

2. Navigate to Integration Hub > Tools > Lookup Tables.
   

   Figure: Navigation
   

3. Lookup Tables page is displayed. Click + New table to create a new Lookup
   
   Figure: Lookup Tables
   

4. Click on the edit icon, enter a name for the Lookup Table.
   
   
   Figure: Create Lookup Table
   

5. Click Save icon to rename the Lookup Table.
   
   
   Figure: Rename Lookup Table
   

6. You can add lookup tables using following methods:

   • Import CSV

   • Add entries manually

   • Use a recipe action to programmatically insert or update data
     

   

   Figure: Add Lookup Table
   

7. To Import as CSV click Import CSV and upload the file.
   
   Figure: Import CSV
   
   In the Specify action section, select one of the following options:

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

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

   Note

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

8. To Add or Edit entries manually, perform the following:

   • Click Add entry.

   • Enter values in each column of the new row.

   • Click ✓ Save to save the entry.

   

   Figure: Add entries manually

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