Once a REST lookup has been defined, it can be used on an integration.
- In the integration navigate to Integration > Additional Columns > Add Additional Columns
- Name – Name of the additional column
- Type – Select REST Lookup
- Instance – Select the REST connector instance where the REST Lookup was defined
- Lookup – Choose the lookup that was defined.
- Late Bound Lookup – Lookup will be processed after all data is calculated, which means the lookup can use a calculated field for the filter criteria.
- Include lookup result in scripting – Lookup will be processed before other additional columns, which means the returned value from the lookup can be used in a calculation.
- Return Fields – Fields that return data when a lookup matches the filter criteria. At least one field needs to be selected.
- If No Data – Select the required option if no data is found.
Option | Description | Late Bound Lookups | Result in Scripting |
---|---|---|---|
Continue | SmartConnect will continue with the integration even if no data is found | Allowed | Allowed |
Return Default Value | SmartConnect will return a default value for all returned fields | Allowed | Allowed |
Restrict line out if data exists | If lookup DOES return data, the integration will not send any lines that use this lookup | Not Allowed | Not Allowed |
Restrict line out if no data exists | If lookup does NOT return data, the integration will not send any lines using this lookup | Not Allowed | Not Allowed |
Return failure for current integration line | SmartConnect will return a failure for that current line that didn’t find a value | Allowed | Allowed |
Stop processing integrations | SmartConnect will stop processing all records if no data has been returned from the lookup | Allowed | Allowed |
- Default Value – Only available if the No Data option is set to Return Default Value.
- Criteria box – Set the filter criteria by selecting your source column.
- Click Save to save the column settings