Due to scheduled maintenance, some areas of our site are currently inaccessible. Thank you for your patience.

Please reach out to sales@eonesolutions.com with any questions.

Using an OData Field Lookup

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. 

 

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

Reset Filters