Data Source Connector – OneDrive Personal

Data Source Connector – OneDrive Personal

After adding and authenticating a OneDrive Personal or MS Graph Connection, you can pull data from an Excel or CSV file in your OneDrive Personal account on a timed refresh using Data Source Connectors, which is the focus of this article.

Adding

Data Source Settings

  • Navigate the side menu to Data Hub > Data Sources
  • Hover over a data source and click the “Settings” icon link ()
  • In Settings, hit the “Add Connector” button
  • Select the relevant option to add the connector

This will refresh the page with the newly added connector ready for configuration.

Nothing has been saved at this stage, so save your connector after making any changes to enable or update it.

Alternatively, if you’re viewing the rows of a data source, you can navigate to the Settings page using the option under the page’s title.

Configuring

After adding the Data Source Connector, you can configure and add the required properties.

Refresh Frequency

The time interval during which data is pulled and refreshed by this connector.

File Location

Enter the file location on Microsoft OneDrive to import data from.

Location should be entered in the following format: ‘FolderName/Folder2/FileName.csv’.

The following file types can be imported as a Data Source: Comma-Separated Values (.csv), Microsoft Excel (.xlsx).

User ID

The User ID, also known as a User Object ID, is required when authenticating with App-Only Access. To locate the User ID, please see Find the user object ID.

Format file

The spreadsheet file must be in .csv or .xlsx format, cannot contain any formula, and must exist in your connected OneDrive Personal Account.

    • Related Articles

    • Form Connector – OneDrive Personal

      This article provides details on linking your app to OneDrive storage using the built-in connector after Connecting to OneDrive (Personal) and authenticating a connection for the connector to use. Alternatively, you can use Connecting to Microsoft ...

    • Connecting to OneDrive (Personal)

      MS Graph Connection Recommended We highly recommend connecting your Microsoft services using the Microsoft Graph integration. As the unified gateway to Microsoft 365, a single MS Graph connection securely authenticates SharePoint, OneDrive, and Excel ...

    • Data Source Connector – OneDrive for Business

      After adding and authenticating a OneDrive for Business or MS Graph Connection, you can pull data from an Excel or CSV file in your OneDrive for Business account on a timed refresh using Data Source Connectors, which is the focus of this article. ...

    • Form Connector – OneDrive for Business

      This article provides details on linking your app to OneDrive storage using the built-in connector after Connecting to OneDrive (Personal) and authenticating a connection for the connector to use. Alternatively, you can use Connecting to Microsoft ...

    • Dropbox - Data Source Connector

      TABLE OF CONTENTS Adding a Dropbox Data Source Connector Our platform enables you to quickly and easily connect your data sources to data from a file in both Dropbox Personal as well as Dropbox for Business. This enables a one-way synchronization to ...