Web Service and Working with XML in NAV/D365 Business Central

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 and I think it’s a good example for learning/practice purposes because it does not require a key and the XML is not too complex:

Bron : Andrei Lungu
Lees meer…

XML Buffer and CSV Buffer Tables

Most of us that’s been programming in Dynamics NAV for a while are aware of the Excel Buffer table. It is a super useful table that can be used to create and read Excel files from C/AL code. This table have been around as far as I remember, and now it has some siblings, the XML Buffer and CSV Buffer tables.

Bron : Olof Simren
Lees meer…

Using comments in XML Port Data

Setup data is one of the hardest things to keep strait in Dynamics NAV. If you have multiple developers on the same database, they might be modifying setup data to develop new features or testing for bugs. When you have setup data being changed constantly, you may not know what the correct setup is for your production system when it is time to push up your new code from the dev or QA system.

Bron : Ryan Erb
Lees meer…

Format XML standard

When you have to format C/AL variables (numbers, dates/times, booleans) for exchange with other apps, call FORMAT(variable,0,9) instead of simply FORMAT(variable). The format 9 formats the variable according to XML standards, and this value can then be interpreted correctly on any system with any regional settings. This is useful also when passing string-formatted values from C/AL to C# or JavaScript.

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…