This feature is now available as part of the July 2025 SmartConnect Update.
- On the Integration tab, click on Additional Columns tab
- Click the Add Additional Column button
- Name – Enter a name for the column
- Type – Select Record Lookup Column from the Type dropdown list
- Role Type – Select the Role Type the lookup will be using
- Return Fields – Select the field(s) that will be returned from the lookup
- If No Data – Select the required option if no data is found
| Option | Description |
|---|---|
| Continue | SmartConnect will continue with the integration even if no data is found |
| Return default value | SmartConnect will return a default value for the output |
| Restrict line out if data exists | If lookup DOES return data, the integration will not send any lines that use this lookup |
| Restrict line out if no data exists | If lookup does NOT return data, the integration will not send any lines using this lookup |
| Return failure for current integration line | SmartConnect will return a failure for that current line that didn’t find a value |
| Return Null | SmartConnect will return a null value |
| Stop processing integrations | SmartConnect will stop processing all records if no data has been returned from the lookup |
- Process Unmapped Column -If the lookup should be ran even when it is not mapped on the target line (useful if output is only referenced in a calculated column)
- Late Bound Lookup – Selected if Calculated columns will be used as an input in this lookup
- Include lookup result in scripting – If the result of the lookup should be available to use in Calculated Columns
- Lookup filter – Define the criteria of the lookup
- Field – Select the field to use for the lookup filter
- Operator – Select the operator for the selected field. The operators will change depending on what type of field is selected
- Field Type – Select the field type, either Source Column or Local Constant
- Value From – Select the Source Column or enter the local constant to be filtered on
- Conditional Return if valid – When defined, Only return a value if condition(s) is met
- Field – Select the source field to be evaluated
- Operator – Select the operator for the selected field.
- Value – Type in the Value to validate against
- Click Save to save the column settings.