The Qlik OneDrive V2 Connector enables you to access data that is located on your personal OneDrive. With the OneDrive V2 Connector, you can select data from files and folder, and load that data into your Qlik Sense app or QlikView document.
The Qlik Web Connectors help you connect to different data sources and fetch data in the same way. Learn how to authenticate a data source connection and how to use tables to fetch data.
- Qlik Sense Desktop
- Qlik Sense Enterprise on Windows
This connector must be installed separately.
Ways to access your data
To access your personal OneDrive account, you need to authenticate the connector with your OneDrive account credentials.
Loading data from tables
After you authenticate the connector with your account credentials, you can use the following tables to select and load data:
|Drives||Returns a list of the available drives for the authenticated user.|
|Items||Returns a list of items for a specific drive and folder. Returns sub-folders and files.|
|Item||Returns an item according to the specified item ID.|
|SearchFiles||Returns a list of items that match a query and are available to the user.|
|RecentFiles||Returns a list of items recently interacted with by the user.|
|FilesSharedWithMe||Retrieves a collection of drive items that have been shared with the user.|
|GetRawFileAsText||Returns a file as text.|
|GetRawFileAsBinary||Returns a file as binary.|
|DownloadFile||Downloads a file to a local path.|