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.
  1. Default Value – Default Value to return if lookup fails to find a record.
  2. 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.
  1. Add additional criteria rows as required.

  1. Click Save.
  2. Click on the ‘Target Integration’ tab.
  3. Column Type – Change to ‘Odata Field Lookup’.
  4. Source Name – Select the Additional Column.

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

We're on your integration team. Connect with our people and let us know how we can help you.