Part 4: Web Services – interface method of choice

If you ask your Microsoft Dynamics NAV partner about interfacing other systems into your NAV system, chances are they will say ‘does that other system support web services?’ So what are web services and why are they the interface method of choice?

Well in the same way at you can type a web address into your internet browser and get a particular page up in your browser, you can type a web services address and access or update particular information using web services. Working securely across your local network, or the full internet, they allow different systems to talk to each other in real time.

What this means is that an external system accessing your Dynamics NAV system via web services can get and update information in real time. That means that, for instance, it can get the number of an item in stock and the current sales price for a particular customer exactly the same as a user accessing the system through the full Dynamics NAV client.

Then if it tries to do a sales order for that item for a particular customer and that item is blocked the web service will send the external system exactly the same error message as if again they were using the full windows client.

The advantage of this real time nature cannot be underestimated. Compared to the batch update method of importing or exporting a file (which may have an invalid value that an administrator then has to sort out) it makes interfacing immediate and seamless. In fact the third party system using the web service is effectively just another type of client to your Dynamics NAV data like the standard Windows, Web and Tablet clients are.

Not only can Dynamics NAV be updated via web services, it can also use them to access or update information in other systems. So for instance with Dynamics NAV 2016, it will talk to Dynamics CRM using CRM’s web services to make sure that as soon as certain information is updated in NAV, it’s also updated in CRM. Because web services are just a type of URL that CRM can be, CRM Online based on Microsoft platform or CRM on your own servers, you just change the ‘address’ you put into NAV’s CRM integration setup table.

So NAV doesn’t have any web services published by default. If you want to see if any have been published on your system simply type web services into the search box in the top right hand corner and access the web services table from there. This also now gives you the ‘web address’ for both the SOAP and OData formats of the published web service. Copy these into your browser of choice, enter your credentials and see the difference for your self.

If none are published note that you can publish any page, query or codeunit. Personally I think creating a specific codeunit with the functions or calls needed is good practice. Having a XMLport as one of the parameters on those function calls allows huge amounts of data to be passed in and out as securely and effectively as possible.

Certainly web services are the interface method you should use if possible. In the future I suspect all systems will support them and any system worthy of being called modern or current does now.

Note

This post is part of a 6-part series. A link to all the posts in this series are below;

Author: James Crowter

I’m passionate about how businesses can improve their efficiency by getting process optimal more of the time. For the last twenty five years I’ve worked to help organisations of all sizes and types implement the ERP & CRM software that typically they decide they need when things are going wrong. I’ve seen that work unbelievably well and enabled those organisations to rapidly grow but I’ve also had some hard projects over that time where it’s felt more like warfare at times. Since 1996 (and version 1.01) I’ve been working with a small Danish product called Navision that’s now become Microsoft’s Dynamics NAV and I’ve also been using and consulting around Microsoft CRM since 2005. As managing Director of one of the longest established first Navision and now Microsoft Dynamics partners I’ve been involved in the complete history including numerous product councils and system design reviews. It’s my privilege to know many of the key Microsoft executives and product designers and have insight into both where the products are now and their future direction. So colleagues & clients have asked me to start this blog to share some of the insight that both this knowledge (obviously where not restricted by NDA’s or client confidentiality) and experience can help. Specifically I want to concentrate not on the specifics of how (there are some great blogs already for that) but why. If any user helps their business make better decisions or consultant can give better advice then that will be objective achieved. I founded Technology Management in 1992 and have led from the front ever since. Helping clients use technology to grow their business is my passion through explaining technology in terms that everyone can understand. My interest in computing began at the age of eight, long before my school had the equipment to cope. Throughout school and university I developed software commercially. I hold many IT certifications, such as Microsoft Dynamics NAV (for over 17 years), Microsoft Dynamics CRM (for over 10 years), as well as Microsoft Windows Server, Exchange and SQL. In October 2015, I was awarded the title of Most Valuable Professional (MVP), a title given to a select few individuals (31 currently) across the world specifically for Dynamics NAV. After years of working with a range of distribution and manufacturing software for hundreds of organisations, I focus on understanding the business requirements of an organisation, what it will take to deliver the systems required to maximise their potential. Follow me online via my other social channels: - Twitter: @jamescrowter - LinkedIn: linkedin.com/in/jamescrowter Or email me directly at james[.]crowter[@]tecman.co.uk.

Leave a Reply

Your email address will not be published. Required fields are marked *