Skip to main content

OneDrive Metadata

The Qlik OneDrive Metadata connector uses the OneDrive API to access your OneDrive metadata, like the names of files and subfolders in your OneDrive account.

Note: This OneDrive Metadata connector is only available in SaaS editions of Qlik Sense. For the client managed version, see Qlik Web Connectors: OneDrive V2.

Supported offerings

  • Qlik Sense Business
  • Qlik Sense Enterprise SaaS

Ways to access your data

To access your OneDrive metadata, you need to authenticate the connector with your OneDrive account credentials. After you create a connection and select OneDrive Metadata as your data source, you are redirected to a OneDrive login page. Log in with your credentials to retrieve an authentication token, and enter it into the connector.

Creating a data source connection

Loading data from tables

After you authenticate the connector with your account credentials, use the tables to fetch your data. Below are use cases for some of the available tables:

Tables that can be loaded Tables that can be loaded
Table Available in Description
Drives Data load editor Retrieve the signed in user's drive.
Items Data load editor Retrieve a file, folder, or other item stored in a drive.
Item Data load editor Retrieve details for an item (e.g. file or folder).
SearchFiles Data manager and Data load editor Search for items matching a query. You can search drive or files shared with the current user.
RecentFiles Data load editor List a set of items that have been recently used by the signed in user.
ilesSharedWithMe Data load editor Retrieve a collection of drive items that have been shared with the owner of the drive. To retrieve shared file details or content use the columns remoteItem_parentReference_driveId and remoteItem_id in other tables.

To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*). The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection.

Creating a connection and selecting data

Working with the OneDrive REST API quota limits

The Qlik Web Connectors use the OneDrive API to extract data from OneDrive and load it into your Qlik Sense app. While reloading your OneDrive-based app, you might receive an error message that the connector has reached the OneDrive API rate limit and that all subsequent API calls will fail until the connector falls back under the throttling limit. If you receive this error message, then you have exceeded one of the API rate limits.

Reference - OneDrive REST API documentation

You can refer to the OneDrive API documentation to learn more about the requirements and restrictions imposed by the OneDrive API.

OneDrive REST API

Troubleshooting

You receive an error message that you have reached the API rate limit

Possible cause

You have exceeded the API limits that are imposed by the OneDrive API.

Proposed action

To reduce the impact of reaching API rate limits, develop your app with the following in mind:

  • Extract only the data you need.
  • Reload one OneDrive-based application at a time.
  • Ensure that loops in your script that make API calls do not result in infinite loops.