I am a Project Manager, tasked with organizing a tool set for my organization's PMO. We have been having issues finding a solution for integrating data from Microsoft Dynamics NAV (preferably two-way) with any of our current tools. The idea is to pull data from Nav (and hopefully sync with NAV from another application) and pool that data with at least one other data source, in a centralized location for the purposes of automated reporting and projections. Specifically, the time and charge code fields would be necessary.
Ideal integrations would be as follows:
Any of these integrations may provide the solution we are looking for. Our organization wants to take data from either Excel or Jira Cloud and combine it with data from NAV to calculate things like Planned vs Actual reports. I understand that things like Webhooks or REST APIs are potentially used, but I am not educated enough in those solutions to know if they would work for what we are intending to do. Alternatively, we would like to find a solution or add on that would allow NAV to sync data from another application to achieve the same result. Does anyone have any suggestions? I am open to applications, add-ons, or procedures to solve this issue. The amount of time spent in manual data entry is what we are attempting to reduce. I am happy to provide more information if necessary.
Hi, Web Service is commonly used in NAV, and you can search for this keyword on the Internet.
Hope the information below can help you too.
https://learn.microsoft.com/en-us/dynamics-nav/microsoft-dynamics-nav-web-services-overview
https://learn.microsoft.com/en-us/dynamics-nav/how-to--publish-a-web-service
https://andreilungu.com/most-simple-web-service-examples/
In addition, if you can upgrade to BC SaaS, the integration with Microsoft 365 will be very powerful.
Hope this helps.
Thanks.
ZHU
hi
dynamics nav can expose API rest very well and make your integration with any system very easy
I attach these examples:
this one from my blog:
danieleincalza.blogspot.com/.../dynamics-nav-2018-my-interface-with.html
and this one from Saurav
community.dynamics.com/.../microsoft-dynamics-nav-2018-api-part-4-develop-custom-api
check my answer if it helped you, thanks
DAniele
Sohail Ahmed
1,200
YUN ZHU
1,006
Super User 2025 Season 1
Mansi Soni
836