Reply To: Connector for Microsoft Dynamics NAV

Network of MS Dynamics D365, AX, NAV, GP, SL, CRM, RMS, POS professionals Forums Reply To: Connector for Microsoft Dynamics NAV



< ![CDATA[Hi Abigail, To start, load this demo app from this Github page. We included a simple demo application showing two use cases of the Dynamics NAV Connector: creating a country with SOAP API and getting the last hundred countries in alphabetical order with OData and SOAP API. Since the demo app uses the Countries/Regions Page, you should publish a paging service with name ‘Countries.’ [Publishing a Page service] Once you load the example, let’s configure the connector. To configure the connector, go to Global Elements, and find the “Microsoft Dynamics Nav Connector.” After selecting it, click “Edit.”
In the ”Microsoft Dynamics NAV Connector” configuration, you can specify the configuration for your Microsoft Dynamics NAV. You could directly add your Server information in the configuration, but we recommend using the properties file to add your configuration information.
Since the connector supports token-based authentication, you need to generate an access token from the Microsoft Dynamics NAV server. Also, since the connector supports SOAP Web Services and OData Web Services (OData Query), the SOAP URL and the OData URL should be specified.
After you complete the configuration for your Microsoft Dynamics NAV environment, run the app, then open up a browser and hit http://localhost:8081. You could see the following HTML page showing you CRUD operations on the countries entity.
As you can see below, when I add a country, Peru, to Microsoft Dynamics NAV, the demo app returns the Country/Region: PE.
You can simply use the first form to execute a simple OData Query which will return the last 100 countries in alphabetical order, but you can also use the DataSense Query Builder which helps you build a query in a more intuitive way.
query builder
When you hit http://localhost:8081/read with your browser or use the first form, you will receive the last hundred countries in alphabetical order. (Your results will be different from the following example.)

Skip to toolbar