Skip to main content

Create HTTP import mapping with static or dynamic lookup

Tom Santiago
  • Updated

This article explains how to use the lookup handlebar at the record level to implement static and dynamic lookups in an HTTP application import.

This lookup option occurs during import mapping, in order to perform an additional query prior to syncing records. Do not confuse this import setting with the lookup flow step, which retrieves additional records or files within your flow. 

Understand lookups

If the data available in your source application is insufficient or incomplete for the purposes of your integration, but the required information can be retrieved from a secondary source, you can use a lookup to supplement source application’s export data. You can use static and dynamic lookups at the record level for an HTTP import of JSON and XML media types. For more information, see Lookup field mapping.

Note: You must be familiar with the expected JSON or XML request body template for the HTTP import. 

Create a dynamic lookup

  1. Click the mappings icon on the import step. The Edit mapping window opens.
  2. Click the gear icon next to the field you are mapping. The Settings window opens.
  3. In the Field mapping type section, click Lookup.
  4. Select Dynamic search in the Options section.
  5. Enter the Relative URI.
  6. Select an HTTP method.
  7. Enter the Resource identifier path.
  8. Enter a unique value in the Name field so that you can identify this lookup later.
  9. Click Save.

Create a static lookup

  1. Click the mappings icon on the import step. The Edit mapping window opens.
  2. Click the gear icon next to the field you are mapping. The Settings window opens.
  3. Click the gear icon next to the field you are mapping.
  4. In the Field mapping type section, click Lookup.
  5. Select Static: Value to value in the Options section.
  6. Enter the appropriate values for Export field value and Import field value.
  7. Enter a unique name in the Name field so that you can identify this lookup later.
  8. Click Save.

Lookup handlebar syntax

You can reference data retrieved from existing lookups in a flow with the following handlebars syntax.

Dynamic mapping:

{{lookup <lookup name> this}}

Static mapping:`

{{lookup <lookup name> this.<Export Field Name>}}

 

Related articles

Comments

1 comment

Date Votes

Please sign in to leave a comment.