Using an Odata Field Lookup

1. On the Integration tab click on ‘Additional Columns’ tab.
2. Click on the ‘Add Additional Column’ Button.
3. Name – Enter a unique name for the column.
4. Type – Set type to ‘Odata Field Lookup’.
5. Service – Select the Web Service to use.
6. Return Field – The field to return from the lookup.
7. If No Data – The action to take if data is not found based on the criteria setup

• Continue – Continue without passing a value into this field.
• Return default value – Return the value in the ‘Default Value’ field.
• Return failure for current integration line – Return an error for the record and don’t send data to the target system.
• Stop processing integrations – Stop processing records.

8. Default Value – Default Value to return if lookup fails to find a record.
9. Filter Fields – click Add Attribute to enter the matching details for the lookup.

• Field – Select the source Field column that contains the data to be matched to the Business Central Data.
• Field Type – select the field type for the selected Field.
• Criteria – select the criteria field that matches the source field.

10. Add additional criteria rows as required.

‍

11. Click Save.
12. Click on the ‘Target Integration’ tab.
13. Column Type – Change to ‘Odata Field Lookup’.
14. Source Name – Select the Additional Column.