Lookup Tables

  • 2 minute(s) read
Prev

Lookup Tables provide a centralized way to define and manage key‑value mappings for integrations. Instead of hardcoding values in workflows, administrators can configure source‑to‑target mappings once and reuse them across flows. This streamlines data transformation, ensures consistency, and simplifies integration maintenance.

Benefits

  • Simplifies data mapping across different applications using reusable lookup values.

  • Ensures consistent data transformation by centralizing mapping logic across integration flows.

  • Centralizes value mappings in a single location.

Configure Lookup Tables

To configure Lookup Tables, perform the following steps:

  1. Navigate to Integration Platform > Lookup Tables.
    The Lookup Tables list page is displayed.

    Figure: Lookup Tables - List

  2. Click + New Table to create a new table.
    The New Table page list is displayed.

    Figure: New Table

  3. Enter the new table Name in the textbox and click Create.
    The Lookup Table page is displayed.

    Figure: Lookup Table

  4. Click to add a Column and row to create a table for mapping.
    The New Column page is displayed.

    Figure: New Column

If you are integrating ServiceNow with Apex to automatically create incidents in Apex whenever a new incident is created in ServiceNow. Create a Lookup Table as displayed, because both applications use different values for incident attributes, Lookup Tables are used to translate these values before creating the Apex record.

Figure: Lookup Table - ServiceNow Integration

Lookup Table in Integration Flow

The mapping converts ServiceNow incident values into their Apex equivalents. When an incident is created in ServiceNow, the integration flow automatically applies these mappings before creating the corresponding incident in Apex.

To Configure Lookup Table in Integration, perform the following steps:

  1. Navigate to Integrations and create a New Integration for mapping.
    The Designer Canvas is displayed.

    Figure: Designer Canvas

  2. Create and configure a Webhook trigger to start the integration flow when a new ServiceNow incident is created and receive incident details from ServiceNow.

    Figure: Webhook - Config

  3. Configure a Lookup Table to maps the required field values before the data is processed by the destination application.

    Figure: Configure - Lookup Table

  4. Select the required lookup table, configure the source and target columns, map the ServiceNow fields (such as Urgency, Impact, and Priority) to their corresponding Apex values, and specify default values for unmapped entries.

  5. On creating a ServiceNow record, create an Apex record and configure it to create an incident in Apex.

    Figure: Create Record
    Map the transformed lookup table values and other incident details, such as Caller, Description, Status, and Symptom, to the corresponding Apex fields.

  6. Add a Custom Code component to convert the attachment object received from ServiceNow into a list of file names.

  7. Add a Loop component to process each attachment individually.

    Figure: Loop Component

    Inside the loop, configure the Get Attachment component to retrieve each attachment from ServiceNow and the Upload Attachment component to upload it to the newly created Apex incident.

  8. Save and Deploy the integration flow to verify that incidents.