Microsoft OneDrive as a Source
  • 3 Minutes to read
  • Dark
    Light

Microsoft OneDrive as a Source

  • Dark
    Light

Article summary

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

To authorize this service, use OAuth 2.0 to share specific data with Dataddo while keeping usernames, passwords, and other information private.

  1. On the Authorizers page, click on Authorize New Service and select your service.
  2. Follow the on-screen prompts to grant Dataddo the necessary permissions to access and retrieve your data.
  3. [Optional] Once your authorizer is created, click on it to change the label for easier identification.

Ensure that the account you're granting access to holds at least admin-level permissions. If necessary, assign a team member with the required permissions with the authorizer role to authenticate the service for you.

For more information, see our article on authorizers.

How to Create a Microsoft OneDrive Data Source

  1. On the Sources page, click on the Create Source button and select the connector from the list.
  2. From the drop-down menu, select your authorizer.
    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.

  3. Name your data source and provide your:
    1. Drive ID (optional): You can find your ID in the URL after cid=.
    2. Path: Provide the name of your directory/folder, e.g. Documents/.
  4. On the File setup step, input your file name and the file format, e.g. example.json.
    DATADDO TIP

    In case of:

    • A CSV file, make sure to use the right delimiter.
    • An XLXS file, you can select a specific sheet and cell range to extract data from.
  5. On the transformation tab, use the default transformation or provide your own transformation pipeline.
  6. Configure your sync frequency or set the exact synchronization time under Show advanced settings.
  7. Preview your data by clicking on the Test Data button in the top right corner.
  8. Click on Save and congratulations, your new data source is ready!

Troubleshooting

Data Preview Unavailable

No data preview when you click on Test Data might be caused by an issue with your source configuration. The most common causes are:

  • Date range: Try a smaller date range. You can load the rest of your data afterward using manual data load.
  • Insufficient permissions: Please make sure your authorized account has at least admin-level permissions.
  • Invalid metrics, attributes, or breakdowns: You may not have any data for the selected metrics, attributes, or breakdowns.
  • Incompatible combination of metrics, attributes, or breakdowns: Your selected combination cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same data source.

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.

Related Articles

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources


Was this article helpful?