BC SaaS : Importing Multiple Files from OneDrive Folder

YA_BF

Hi all,

We are trying to come up with a solution where we can import multiple CSV files stored in a folder in OneDrive into Business Central SaaS. We do not have the option to map the OneDrive somewhere locally since even Business Central is cloud based therefore no VM or server.

Scenario;

We have an external system set to dump CSV files in a OneDrive Folder which needs to be imported in a table in Business Central SaaS (not on-prem). Is it possible to create a Codeunit (or Report) that reaches a folder in OneDrive and imports the multiple CSV files within that folder (or at least one)?

Thank you in advance!

YA_BF

We have sorted this differently by changing our Flow to push data to BC directly rather than dumping CSV files but we were only able to create Purchase Invoices, not POs.

ftornero

Hello @YA_BF,

Take a look to this:

https://www.youtube.com/watch?v=5jdwO6d_UEQ&list=PLI1l3dMI8xlCkFC0S4q8VxPiBt30VQ4w0&index=7&t=0s

Regards

YA_BF

We have sorted this differently by changing our Flow to push data to BC directly rather than dumping CSV files but we were only able to create Purchase Invoices, not POs.

ftornero

Hello @YA_BF ,

It looks a little strange because is only other option in the field "Document Type".

Regards