# OneDrive as a source - How to access the files?

**URL:** <https://community.dataddo.com/t/onedrive-as-a-source-how-to-access-the-files/28>\
**Category:** How To\
**Created:** [November 27, 2024, 7:34pm UTC](https://community.dataddo.com/t/onedrive-as-a-source-how-to-access-the-files/28 "2024-11-27T19:34:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anashathif](https://avatars.discourse-cdn.com/v4/letter/a/f04885/32.png) [@anashathif](https://community.dataddo.com/u/anashathif)\
**Post date:** [November 27, 2024, 7:34pm UTC](https://community.dataddo.com/t/onedrive-as-a-source-how-to-access-the-files/28/1 "2024-11-27T19:34:44Z")

</div>

Issue:  
Sometimes in the OneDrive as a source, clients face difficulty in defining the path of the file that they would like to use. This guideline will help you to overcome this issue.

Solution:  
The path would be the folder in their oneDrive account, for e.g. if there is a folder called / **testing** / (SS below)

 ![SS](https://canada1.discourse-cdn.com/flex009/uploads/dataddo/original/1X/8ea538f9a416c4b82ae5f885015391ddeff29017.png)

and within that folder if there is a csv file called test.csv → (SS1 below)

 ![SS1](https://canada1.discourse-cdn.com/flex009/uploads/dataddo/original/1X/30e8ab14b1db20f77c67ce8ba36f4881dcc42225.png)

Then this is how the file can be extracted:

In the oneDrive connection setup step, they will fill their cid= (which is found in their oneDrive URL (mentioned in our docs [here](https://docs.dataddo.com/docs/microsoft-onedrive-source#how-to-create-a-microsoft-onedrive-data-source) - check point 3, Drive ID) and then to access the files within the folder testing, the path will be defined as such: /testing/ (SS2 below)

 ![SS2](https://canada1.discourse-cdn.com/flex009/uploads/dataddo/original/1X/bf8bf058bfb76b753353cc17366273b28af0ffb6.png)

Finally in the file setup step, they will select the file format, whether it is a csv, json, xml, xlsx or parquet file. Here in my case, it is a csv format, so I select that and then in the file name I define the name of the file as it is shown in my oneDrive account (test.csv, SS1) → note if the file name contains the extension type, then please do include it (here in this case it is .csv). (SS1) (SS3 below).

 ![SS3](https://canada1.discourse-cdn.com/flex009/uploads/dataddo/original/1X/b0087da1dd0adde30e693cf91d62a05f29633de2.png)