Office 365 SharePoint Connector
With the Qlik Office 365 SharePoint Connector allows you to retrieve data from your SharePoint account.
Ways to Access Data
To access your Office 365 SharePoint data, you must verify the connection. Enter the SharePoint base URL you want to connect to, click Verify and log in with your SharePoint account data. Get the authentication token and enter it into the connector. Your login details are stored in the Qlik Web Connectors.
Load data from tables
After you verify the connector with your account information, you can use tables such as the following to select and load data:
Sub Sites
Retrieves available subsites from your Sharepoint account.
Lists
Retrieves available lists.
Groups
Get available groups.
UsersInGroup
Retrieves available users in a group. You need the group ID to run this table.
Working with the SharePoint REST API quota limits
De Qlik Web Connectors use the SharePoint REST API to extract data from Office 365 SharePoint and load it into your app. While reloading your Office 365 SharePoint-based app, you may receive an error message that the connector has reached the SharePoint REST API speed limit and all subsequent API calls will fail until the connector falls below the throttling limit. If you receive this error message, you have exceeded one of the API speed limits.
Troubleshooting
You receive an error message that you have reached the API limit.
Possible cause
You have exceeded the API limits set by the SharePoint REST API Qlik Web Connectors are imposed.
Proposed action
To reduce the impact of reaching the API speed limits, develop your app with the following in mind:
- Extract only the data you need.
- Reload an Office 365 SharePoint based application at the same time.
- Make sure that loops in your script that make API calls don't lead to infinite loops.