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.
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!