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

SFTP and BC SaaS

(0) Share

Report

Posted on by AntonisK

171

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:

Business Central

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 73,339 Super User 2024 Season 2 on at

Like (0)

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
AntonisK 171 on at

Like (0)

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