Hi Guys
Is it possible set up a process to automatically create sales orders from a CSV file stored on OneDrive or FTP folder? Or is there another way to integrate files from external sources?
Thanks
Once the CSV is ready for import you could use this method: https://youtu.be/cp91N4xFqlg
As for getting the data there if it was mean I would look at power automate or logic apps as you have a connector for OneDrive or FTP. Once the file is retrieved you will need something custom to have it imported to BC. I’m unthinking you could use a codeunit that is published as an unbound action in the web services page. You can then use the HTTP connector in power automate or logic apps to POST the CSV file. The codeunit could then take the stream of the file and unpack it with CSV buffer table.
You can use Skyvia to import CSV files from OneDrive to Dynamics using Skyvia: skyvia.com/.../onedrive. It supports both manual or automatic data import by schedule.
Hi, just adding to others' reply, You can investigate Microsoft Graph API.
More details:
https://docs.microsoft.com/en-us/graph/use-the-api
https://www.msnjournals.com/post/how-to-use-microsoft-graph-api-in-business-central
Hope this helps.
Thanks.
ZHU
I think you should consider putting the CSV files on a Azure blob storage.
There are now support in AL for handling files on a Azure blog storage and it works very well.
Thanks. I think Azure blog storage and container is the best option with full capability to transfer and monitor file movements
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 4,160
Nimsara Jayathilaka. 2,943
Sumit Singh 2,823
