Small and medium business | Business Central, N...

AL Code for Integration between Business Central and External Sales System via API

(4) Share

Report

Posted on by Lama Khaled

Hello,

I'm looking for some guidance on how to write AL code in Visual Studio Code to establish a continuous integration between Microsoft Dynamics 365 Business Central and an external sales system via API.

Specifically, I want to achieve the following:

Retrieve customers and sales invoices created in the external sales system and import them into Business Central.
Continuously synchronize item details from Business Central to the external sales system.

Most examples I've come across online demonstrate integration using Postman, but I'm specifically interested in implementing this functionality using AL code in Visual Studio Code.

I would greatly appreciate any advice, tips, or resources that can help me accomplish this task efficiently.

Thank you in advance for your assistance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,213 Most Valuable Professional on at

Like (3)

Report

Hi

I hope this can help you. And give you some hints. Extending standard APIs (2) – Kauffmann @ Dynamics 365 Business Central

BR

GR

Was this reply helpful? Yes No
Lama Khaled 12 on at

Like (2)

Report

Hi,
Thanks, gdrenteria for your reply but I need the basic steps to start creating AL code for the connection between BC and the second system, the URL for the document you sent has a complicated way that isn't useful for me because I'm a beginner can you advise?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (3)

Report

Hi, you can search for the "HttpClient data type" keyword and you should be able to find a lot of learning materials.

For example,

Call external services with the HttpClient data type

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-httpclient?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Lama Khaled 12 on at

Like (2)

Report

@YUN ZHU

Hi Mrs,

Thanks for your advice on using HTTP data type, I searched and found about this but I need to use AuthO type to use secret ID and token, and how I make an integration between an Outside system with Business Central to get and post data between them, how I can apply the mapping between them, I need example code if you can ? I apprsieated your effort but I need someone to give me the light of the road in this matter because I am a beginner and first time I will do that

Was this reply helpful? Yes No
CU16041327-0 12 on at

Like (2)

Report

@Lama Khaled Where you able to do the integration? Because I'm also a beginner and i want to learn.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,347 Super User 2025 Season 2 on at

Like (2)

Report

Hope this helps:https://www.youtube.com/watch?v=d0Ht3dlpzhc

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/integration-overview

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-custom-api

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-get-started

https://learn.microsoft.com/en-us/dynamics365/business-central/shopify/synchronize-items

Was this reply helpful? Yes No
Matteo Fiocco 260 on at

Like (1)

Report

Hi Lama,

You can achieve this using AL with HttpClient and scheduled Codeunits. For importing customers and sales invoices, create a Codeunit that makes GET requests to the external API and maps the JSON response to BC records. For item sync, use a similar Codeunit with POST/PUT requests to push updates.

Set up Job Queue Entries to run these Codeunits on a schedule for continuous sync. Make sure to handle auth (e.g., Bearer token) via request headers.

Let me know if you need a sample structure!

Cheers,

Matteo

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,213 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

https://businesscentralgeek.com/how-to-connect-to-external-apis-from-business-central-http-request

https://fredborg.org/?p=973

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-httpclient?wt.mc_id=MVP_354389

Best Regards
Gerardo

Was this reply helpful? Yes No