Using a Service Lookup

Published: Jul 11, 2023

Using a Service Lookup

Published: Jul 11, 2023

Once a REST lookup has been defined, it can be used on an integration. 

  1. In the integration navigate to Integration > Additional Columns > Add Additional Columns
  2. Name – Name of the additional column
  3. Type – Select REST Lookup
  4. Instance – Select the REST connector instance where the REST Lookup was defined
  5. Lookup – Choose the lookup that was defined. 
  6. 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. 
  7. 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. 
  8. Return Fields – Fields that return data when a lookup matches the filter criteria.  At least one field needs to be selected. 
  9. If No Data – Select the required option if no data is found.
OptionDescriptionLate Bound LookupsResult in Scripting
ContinueSmartConnect will continue with the integration even if no data is foundAllowedAllowed
Return Default ValueSmartConnect will return a default value for all returned fieldsAllowedAllowed
Restrict line out if data existsIf lookup DOES return data, the integration will not send any lines that use this lookupNot AllowedNot Allowed
Restrict line out if no data existsIf lookup does NOT return data, the integration will not send any lines using this lookupNot AllowedNot Allowed
Return failure for current integration lineSmartConnect will return a failure for that current line that didn’t find a valueAllowedAllowed
Stop processing integrationsSmartConnect will stop processing all records if no data has been returned from the lookupAllowedAllowed
  1. Default Value – Only available if the No Data option is set to Return Default Value.
  2. Criteria box – Set the filter criteria by selecting your source column.
  1. Click Save to save the column settings

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters