Read – Pardaan.com

Read Committed Snapshot isolation and the Write Skew anomaly

Much has been said recently about the benefits of the Azure SQL for Business Central performance, and in particular a few articles focused on Read Committed Snapshot Isolation (RCSI) and the performance gain it brings about. RCSI is an option that must be explicitly enabled in…

21 December 2023

Dynamics NAV & BC Tips & tricks

Sales APIs returns error in a read-only request

Apparently, the PowerBI connector is adding the header Data-Access-Intent: ReadOnly to requests when loading data from Business Central. While this is a good practice in general for GET requests, you may run into an error message with the sales APIs. This applies to salesQuotes, salesOrders and…

20 October 2022

Dynamics NAV & BC Tips & tricks

How to read files via SFTP in Business Central

In this post, I am going to explain how to connect and read a file on an SFTP server and create a record in Business Central automatically through Azure Functions and Power Automate. Source : Ivan Singleton Read more...

5 September 2022

Dynamics NAV & BC Tips & tricks

Read Server & Tenant Settings from C/AL Code

Back in April 2015 I wrote an article about reading server settings with C/AL code. Unfortunately, that code didn’t work in NAV 2015 and above. However, the question pops up now and then, and I decided to give it another try. Being curious myself, of course……

1 November 2016

Dynamics NAV & BC Tips & tricks

Reading from and writing to the Clipboard

Have you ever tried putting something in the clipboard? Well, aside from literally copying or pasting? If you have ever tried something like this in .NET, you might remember, you need to call the functionality in a thread with STA mode. Try doing this in your…

28 October 2015

Dynamics NAV & BC Tips & tricks

Read Server Settings from C/AL code

In this example I will show how to read the server settings directly from NAV code. Without the need to know the location of the config file or to create an external .Net dll. Also PowerShell isn’t needed, and you don’t need any information about the…

13 April 2015