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.
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:
| 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 (*). 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.
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.