Creating a Dynamics NAV OData Bulk Data Source

Published: Mar 10, 2023

Creating a Dynamics NAV OData Bulk Data Source

Published: Mar 10, 2023

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

63c833a829a85bdca3eb6994 QuerySourceLocation

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

63c833c24a17bcfc29f07ac8 CreateBulkQueryButton

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

  63caea7a71f31f77ff55e4be NAVOdataQueryIcon

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

63caea8d0bf4f689afa877f0 NAVOdataQueryWindow

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. 

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

Reset Filters