OAuth for Business Central On-Premises Service to Service Authentication

Introduction There are already many great posts online and even Microsoft presentations that explain how to Authenticate to Business Central using OAuth 2.0. But most of them are focused on the cloud version. As I’ve been asked to blog about how OAuth 2.0 Business Central Authentication can be used for the On-Premise version and I…

How to create a generic “Middle Tier” for BC Web Services using Azure Functions

Introduction There might be situations when an external app needs to use Business Central web services but you don’t want it to access directly the BC web service. Instead we can have something like a “middle tier” app which does the following: – receives requests from external world, – sends requests to BC – receives…

Cross Session Events and SELECTLATESTVERSION – MS Dynamisc Nav / Business Central

Introduction Recently I worked on something very interesting related to a integration between MS Dynamics Nav and an external payment service provider. I had to use custom Cross Session Events to solve a problem which I think it’s worth sharing. So this why this post. Basically, it is about doing some action in a NAV…

How to Use Recursion to Handle Pagination with Continuation Tokens in a D365 Business Central JSON API Integration

Introduction Recently I encountered the following situation in Business Central with Web Service that uses Pagination with Continuation Tokens: –> When you get data from Web Service and it returns a lot of results, the data is paginated. –> One method to handle pagination is using Continuation Tokens. –> For example, look at the below…

Use Unix Time Stamp to Calculate Expires_On from Web Service Response in Business Central AL

What is a Unix Time Stamp? As per Wikipedia, a Unix Time Stamp is a BigInteger value that represents the number of seconds that elapsed since the time 00:00:00 UTC on 1 January 1970. For example using this converter you can see that the Unix Time Stamp ‘1588400673’ represents date time ’05/02/2020 @ 6:24am (UTC)’.…

Distance Calculator for Business Central – Another way to Import Response from Web Service into Business Central Wave 2

Introduction In this post I presented a very simple way to import data from Web Service Response into Business Central Wave 2. However, that approach is not a generic one. Let’s now create a Distance Calculator for Business Central that can be used in real life. The current post presents a better way to Import…

Using REST Web Service to Import Json Data in Business Central

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…

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…