Share
ReportHi All
I have some CSV files that need to be imported into Business Central Saas from a FTP location. How can this be achieved?
Currently i import manually through XML Ports.
Thanks
You’re offline. This is a read only version of the page.
115
Hi All
I have some CSV files that need to be imported into Business Central Saas from a FTP location. How can this be achieved?
Currently i import manually through XML Ports.
Thanks
First you need to map a drive directly to your FTP site from within Windows.
www.thewindowsclub.com/map-an-ftp-drive-windows
You can automate import process by using :
Hi,
Are you looking to fully automate the import?
If so, I would recommend looking into Power Automate (formerly Flow). It has FTP and SFTP connectors, can work with CSV files, and there are a few Business Central connectors.
However, depending on the complexity of the data (parent child records, etc.), you might encounter a limitation working with the data directly in Power Automate, and you may need need to bring the CSV data into staging tables in an Azure SQL Database (or some type of staging repository) before importing.
Also, the BC import destination you need might not yet have a Power Automate connector. It is possible to create a custom connector to a different BC API endpoint, but that will require some research and testing to determine if it will meet your needs.
Please let me know if you have any questions or need any additional information.
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
All responses (
Answers (
