HTTP Import: Static and Dynamic Lookups

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

This article contains the following sections:

• Understand Lookups
• Lookup handlebar syntax
• Static and dynamic lookups for JSON
• Static and dynamic lookups for XML
• Create a dynamic lookup
• Create a static lookup

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

Note: You must have the JSON/XML template for the HTTP import. 

Lookup handlebar syntax

Dynamic mapping:

{{lookup <lookup name> this}}

Static mapping:

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

For more information on handlebars syntax, see Handlebars Syntax.

Static and dynamic lookups for JSON

The following image illustrates the syntax to specify static and dynamic lookups for an HTTP import where the media type is JSON.

Static and dynamic lookups for XML

The following image illustrates the syntax to specify static and dynamic lookups for an HTTP import where the media type is XML.

Create a dynamic lookup

Use the following steps to create a dynamic lookup:

1. On the Map page, click View Mappings.
2. Click Manage Lookups.
3. Click + New Lookup.
4. Select Dynamic:Search.

   

5. Enter the Relative URI.
6. Select an HTTP Method.
7. Enter the Resource Identifier Path.
8. Name your lookup.
9. Click Close.

Create a static lookup

Use the following steps to create a static lookup:

1. On the Map page, click View Mappings.
2. Click Manage Lookups.
3. Click + New Lookup.
4. Select Static: Value to Value.
5. Enter the appropriate values for Export Field and Import Field.
6. Name your lookup.
7. Click Close.