Skip to main content Skip to complementary 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.

Qlik Cloud Government noteQlik Cloud Government users have additional Microsoft data sources to access government services. US Government data sources are named according to the environment they connect to, such as OneDrive Metadata GCC High.

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.

Information noteTo ensure continuous access, the refresh token is stored so it can be used to update the connection automatically. This is done to avoid timeouts and token expiration. If the connection is not used for 90 days, the token will expire and you must refresh authentication manually.

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
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.
FilesSharedWithMe 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 (*) in the dialog. 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.



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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!