D365 Business Central : Using Query to Get Distinct Values

When working with table data, there will be times when we need to retrieve a unique record value from the table (also called SELECT DISTINCT). Unfortunately, D365 Business Central does not provide this logic out of the box. We will need to find a way to do this ourselves.

Source : That NAV Guy
Read more…

Working with SOAP API and XML in AL. Generic API codeunit.

The purpose of this post is to learn the basics of working with XML and SOAP in AL. Besides, we’ll look at my suggestion of the generic API method SendRequest(), which fits most APIs without authorization. The authorization itself is not difficult to add to the general logic, but in the post, they are not considered due to their large number and often unique logic

Source : Volodymyr Dvernytskyi
Read more…