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.
