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

SFTP and BC SaaS

(1) Share

Report

Posted on by AntonisK

260

Greetings to all of you.

I have a case which requires to connect to ftp server , get a json file and push the data to BC.

The ftp server is not hosted on Azure so that i will be able to access it and handle the files with azure blob storage.

I am also having trouble to connect to this ftp server through Power Automate.

Do you have any suggestion on how can i achieve the requested need?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

AntonisK 260 on at

Like (1)

Report

SFTP and BC SaaS

UPDATE:

I finally managed to get the json file, through power automate sftp connector.

So now, i have a 60 MB json file which i will need to import the data of this file, to BC, on a daily basis.

As far as i understand, the file size huge for a power automate solution to handle.

What i am thinking of , is to create a custom sftp server of mine to Azure, so that i can push the json file there, and then access this file with the aid of Azure Blob Storage, through AL code.

I am not sure how i will be able to iterate through such a big file ( it has a complex json structure as well) , but i might need to think the solution step by step.

Any thoughts regarding the above? Do you believe is there any other way to deal with json files from external SFTP's?

Thank you in advance,
Antonis

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

SFTP and BC SaaS

Hi, have you considered the solution of Azure Logic App and Azure Function, which has much better performance than Power Automate.

Hope the following helps.

https://demiliani.com/2021/12/07/dynamics-365-business-central-handling-files-via-ftp-on-saas/

Thanks.

ZHU

Was this reply helpful? Yes No
PhillipsB 102 on at

Like (0)

Report

SFTP and BC SaaS

You can try Skyvia. It is a third-party tool for data integration. It doesn't support JSON upload or download, but you can automate the process of transferring data from FTP to Business Central using CSV format.

You can find more information here.

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

SFTP and BC SaaS

The best way to achieve it using azure logic app.

Was this reply helpful? Yes No