Skip to main content

OneDrive V2

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.

Tip note

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.

Connecting to data sources

Supported offerings

  • Qlik Sense Desktop
  • Qlik Sense Enterprise on Windows
  • QlikView

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:

Tables that can be loaded
Table Description
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.