Because I didn’t write on the blog since a long time, today I will demonstrate how you can use the AL language in Microsoft Business Central to import data exposed by a REST Web Service in JSon format. As usual, I created a practical example to demonstrate better the concepts. What REST Web Service we…
DetailsIntroduction In this post I demonstrate how you can get XML data from a Web Service and then process the XML in NAV in order insert the needed values into a table. I made the example using a service provided by the National Bank of Romania. This Web Service, gives Exchange Rates in XML format…
DetailsToday I want to present how to use Excel Buffer functionality in order to update/import data in NAV/D365 Business Central based on data from Excel files. Example of what we want to achieve To show the concept I made a very easy example, so let’s suppose we have the following customers with Location Codes: And…
DetailsI recently looked into a support incident where there were some problems when importing text data from an XML file into NAV. One of the problems was that in the xml file the string contained a lot of useless extra spaces. It looked somehow similar to this: So, in order to fix this, I created…
DetailsIn this post I described a way to deal with Extension Files Info in NAV AL (Business Central). Now I decided to create a small module that will help you manage the Extensions and Ids. Besides what I showed in the first post, I added to the module an extra feature: now you have the…
Details
