Please wait
Talk to Expert
Microsoft Azure AD, Microsoft Dynamics Business central

Integration of Business Central with SFTP Server: Read XML file from SFTP server using Azure Function App and AL

Part 4 Banner SFTPBC Integration

In the world of business applications and systems, transferring data securely across various platforms is a critical task. Microsoft Dynamics 365 Business Central (BC) often requires integration with external systems for various purposes, such as retrieving data from external file sources, automating tasks, or sharing information with third-party systems. In this context, reading XML files from an SFTP server can play a crucial role in automating workflows.

In this blog, we will see how we can access and read data of file which is available on SFTP server using AL code and Azure portal function.

Here’s the Step-by-Step Guide

1. Create one directory in SFTP to add file in it. In this example we have created directory named “out”.

We need to add file in “out” folder of SFTP, to read data of it through Business Central and Azure function.

File contains below details in it.

2. Now, let’s write AL code to access the data through Azure Function App, that we have created in C#.

3. Create an action to execute the code unit.

We have added code to read and print output in message. See below screenshot details has been displayed in message.

Thank you for completing our blog series! If you missed Part 3, you can catch up by Clicking here. Alternatively, if you want to start from the beginning, Click here.

If you’re curious about how we can assist you in reaching your goals, don’t hesitate to get in touch. Our dedicated team is ready to provide support every step of the way.

Let’s turn your vision into reality together!


Comments