---
title: "Microsoft OneDrive as a Source"
slug: "microsoft-onedrive-source"
description: "Securely integrate data from OneDrive with Dataddo's no-code platform. Sync your files and reports in real-time, ensuring seamless access and insights."
tags: ["Database as a source", "Custom-schema connector", "How-to guide", "Data source"]
updated: 2025-10-07T16:51:56Z
published: 2025-10-07T16:51:56Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft OneDrive as a Source

**Microsoft OneDrive** is a cloud-based storage service provided by Microsoft that allows users to store and access their files and documents from anywhere. It offers seamless integration with various devices and applications, enabling users to easily sync, share, and collaborate on their files while providing a secure and reliable storage solution.

## Authorize Connection to OneDrive

{{snippet.Authorization OAuth 20}}

For more information, see our article on [***{{glossary.authorizer}}s***](https://docs.dataddo.com/docs/authorized-services){target="_blank"}.

## How to Create a Microsoft OneDrive Data Source

1. On the **Sources** page, click on the [**Create Source**](https://app.dataddo.com/sources/new){target="_blank"} button and select the connector from the list.
2. From the drop-down menu, select your ***authorizer***.  
    :::(Warning) (**Didn't find your authorizer?**)
    Click on **Add new Account** at the bottom of the drop-down and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new){target="_blank"}.
    :::
3. **Name** your data source and fill in the following **optional** fields:
    1.  **Drive ID**: After logging in to OneDrive, the ID is the string in the URL after `cid=`.
    2.  **Path**: Select your directory, folder or input the name manually, e.g. `/Documents/`.

### Configure Your File

{{snippet.DB-Source FileSetup}}

### Finish Your Source Configuration
1. In the **Transformation** step, if needed, you can:
    1. Set the **Transformation engine** to be **MongoDB** or **JQ**.
    2. Then, manually edit the [transformation pipeline](/docs/transformation-pipeline){target=`_blank`} to fine-tune how your data is processed before reaching the destination.
2. Configure your [**sync frequency**](https://docs.dataddo.com/docs/extraction#extraction-frequency){target="_blank"} or set the exact synchronization time under **Show advanced settings**.
3. Preview your data by clicking on the **Test Data** button in the top right corner. You can **adjust the date range** for a more specific time frame.
4. Click on **Save** and **congratulations, your new data source is ready!**

***
## Troubleshooting
{{snippet.Troubleshooting BrokenView}} 

### Can't Find File
**ERROR MESSAGE**
`itemNotFound - The resource could not be found.`

This issue might be caused by the following:

* **Empty or improper file path**: Make sure the field with file path is filled in. To find the file path, in your OneDrive, identity your file, click on the three dots and select **Details**. Scroll down to **Path** and copy everything after "My files".
    * E.g. If your path shows "My files > Documents > example.json", provide `/Documents/` as the file path.
* **Partial file name**: Make sure to **include** the file extension in the file name to locate it, e.g. `example.json` and not just `example`.

{{snippet.Troubleshooting RelatedArticles}}