BC SaaS : Importing Multiple Files from OneDrive Folder

YA_BFYA_BF Member Posts: 7
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!

Best Answer

  • YA_BFYA_BF Posts: 7
    Accepted Answer
    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.

Answers

  • ftorneroftornero Member Posts: 292
    Hello @YA_BF,

    Take a look to this:



    Regards
  • YA_BFYA_BF Member Posts: 7
    Accepted Answer
    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.
  • ftorneroftornero Member Posts: 292
    Hello @YA_BF ,

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

    Regards
Sign In or Register to comment.