Knowledge Base

Using an OData Field Lookup

How can we help?

Browse Common Categories

Getting Started with

Using an OData Field Lookup


1. On the Integration tab click on the Additional Columns tab.

2. Click on the Add Additional Column button.

3. The Additional Column window will open.

4. Name – Enter a name for the column.

5. Tab off the Name field to enable the Type field.

6. Type – Select OData Field Lookup from the Type dropdown list.

7. Service – Select the name of the web service to be used.

8. Return Field – Select the field that the OData lookup should return from the service.

9. If No Data – Select one of the following options:

Continue – Integration will continue to run even if no data is found.
Return default value – The lookup will return the default value if no data is found.
Return failure for current integration line – The current record will return a failure is no data is found.
Stop processing integrations – The integration will stop processing if no data is found.

10. Default Value – Enter the default value here if “Return default value” is used on the If No Data field.

11. 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 Dynamics NAV data.
Field Type – Select the field type for the selected Field.
Criteria – Select the criteria field that matches the source field.

12. Add additional criteria rows if required.

13. Save the settings.


Email an Expert

Start a Ticket

Chat with Us


Submit a Ticket


Call Us

  • Microsoft Dynamics 365
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2023 SmartConnect|eOneSolutions
Cloud Terms of ServicePrivacy PolicyTerms of ServiceEULA

How can we help?