Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Richard Jenkins
Contributor
December 16, 2024

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?

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
1 vote
Answer accepted
Hun Chan
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 16, 2024

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
Contributor
December 17, 2024

'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
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 17, 2024

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.

Like Steffen Opel _Utoolity_ likes this
TAGS
AUG Leaders

Atlassian Community Events