Knowledge Base

Creating a Dynamics NAV OData Bulk Data Source

How can we help?

Browse Common Categories

Getting Started with

Creating a Dynamics NAV OData Bulk Data Source


1. On the left side options column expand Data Sources, expand Bulk Sources, and click on Query. 

2. On the Query Data Sources page click the Create Bulk Query button. 

3. On the New Query Data Source page click the Microsoft Dynamics NAV OData Query button. 


4. The page to configure the Dynamics NAV OData Query opens. 

5. Enter a Description for the query. 

6. Connection – Select the NAV OData connection to be used from the dropdown list. 

7. Click Validate. If the connection is successful, the Company field becomes active. 

8. Company – Select the company to be used from the dropdown list, this will activate the Services button. 

9. Services – Click the Add Service button to select the name of the web service to be used in the query. A filter can also be applied at this time if the data needs to be filtered down.  

10. After a service has been selected, the save and preview buttons will be enabled.  

11. If multiple services have been selected, then click on Edit Query to join the services together.  

12. Preview button – Allows the user to preview the data that will be returned with the query. 

13. Click Save to save the query source. 


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?