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…

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)’.…

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…