Excel Buffer Patterns for Import or Update NAV Data from Excel Files

Today 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…

How to Create a Simple Json File in NAV C/AL and AL

Because I needed it today for simulating a response of a web service in a unit test and couldn’t find a suitable example over the internet, let’s see how we can create a Simple Json file in NAV C/AL. Sample test codeunit: Variables function Create SimpleJsonFile: Var Name DataType Subtype Length Yes JSonResponse DotNet Newtonsoft.Json.Linq.JObject.’Newtonsoft.Json,…

Most Simple Web Service Examples to Update NAV Data from External App

In this post I demonstrate two Simple Web Service examples of updating a NAV table from an external application using SOAP Web Services. We have table “Person Test” with “Person List” and “Person Card” pages and 3 fields which look like this: And we will create a C# Console Application in Visual Studio that will…