Will ADM Flat file suport pulling files from a OneDrive folder?

[Richard Jenkins]

I have a use case where our shared storage is on OneDrive. Can we point the flat file adapter to a OneDrive folder to ingest the csv file? If so, what is the format of the folder path?

[Hun Chan · Accepted solution]

Hi Richard,

Sure you can. In the OneDrive folder, right click on the CSV file that you want to ingest and select "copy as path". Paste this into the file path box of the flat file configuration in Adapters. Make sure you remove the double quotes (if any) on the file path box. After you have defined the delimiter, qualifier ad column mappings, save the job and execute the job from the adapters client. That should upload the content of the CSV file into Assets Data Manager.

[Richard Jenkins]

'Copy as path gives' me a local drive path that starts with "c:\". I am assuming that it is a local file on my local drive that is synced up to oneDrive.

I have the adapter on a vm running 24/7 so it can do updates. If I have the adapter on a schedule to run while my local is not online, how will the adapter pull in the file that is on my oneDrive? Does this mean that I need to have oneDrive desktop installed on the computer that is running the adapter so that the local and online drive is always synced?

[Hun Chan]

Q: 'Copy as path gives' me a local drive path that starts with "c:\". I am assuming that it is a local file on my local drive that is synced up to oneDrive.

A: YES!

Q: Does this mean that I need to have oneDrive desktop installed on the computer that is running the adapter so that the local and online drive is always synced?

A: YES!

Q: I have a use case where our shared storage is on OneDrive. Can we point the flat file adapter to a OneDrive folder to ingest the csv file? If so, what is the format of the folder path

A: You could also use the Universal Naming Convention (UNC) path in the file path field/box in the flat file configuration if you know the server name and the shared resource name. A valid UNC path must have at least two path components; the server name and a shared name. There are no drive letters like C: or D: An example of a UNC path could be \\servername\shared-resource-pathname i.e. \\MYSERVER\MYFOLDER\test.csv 

The assumption is firewall rules are set up so that the adapter client can access the "test.csv" file.