Skip to Content

Create a Wevo iPaaS lookup table

Lookup tables are a functionality of the Wevo iPaaS platform that interpret and convert values. They behave similarly to dictionaries, with a value that can be located through a key. They help you convert data between two systems.

For instance, integrating products between your ERP and your e-commerce platform. Suppose you have a product category that is listed as a word in your e-commerce platform, but in your ERP, it is listed as a numerical ID. In a scenario such as this, a lookup table can convert this piece of data to facilitate the integration, that is, the word that serves as the product name will be turned into an ID so that the data can flow into your ERP.

This video (provided in Portuguese) demonstrates the lookup table creation process:

Overview

Under Storage, click Lookup Table to see a list of existing lookup tables:

create a lookup table step 1

  • Navigation: In order to navigate between the pages, use the left arrow and right arrow buttons. Notice there is a counter showing how many pages of records are available. To update the information, click the Refresh button.

    navigate between lookup tables

  • Filter By: On the left side of the screen, there is a search field. You can type the name of the record of the Key in order to search for a specific item. You may also choose to see only records that are active or inactive. Click on the respective checkboxes to use the filters.

  • Add New Lookup Table: Click this button when you are ready to create your new lookup table. See a full description of how to do so in the section below.

Create a lookup table

  1. In the upper right corner of the screen, click Add New Lookup Table.

    create a lookup table step 2

  2. Under Lookup Table Name, click the edit icon to create a name. If your organization has naming conventions, it is a best practice to follow them.

    Important

    Do not use spaces in the name, as doing so will cause syntax errors that will prevent you from saving.

    create a lookup table step 3

  3. After choosing a name, click the icon highlighted below to save.

    create a lookup table step 4

  4. Keep the toggle switched to On so that the lookup table will be active, then click Save Lookup Table to finalize the process.

    create a lookup table step 5

  5. Return to the list of lookup tables by heading to Storage > Lookup Tables and the new table you've just created will be listed.

    create a lookup table step 6

In order to be used, the lookup table needs to have data added to it in the form of records, which are key/value pairs. To learn how to do that, see Add or alter data in a lookup table.