Office 365 Sharepoint

The Qlik Office 365 Sharepoint connector lets you fetch data from your Sharepoint account.

Ways to access your data

To access your Office 365 Sharepoint data you will need to authenticate the connection. Enter the Sharepoint base URL to which you want to connect, click Authenticate, and log in using your Sharepoint account credentials. Retrieve the authentication token and enter it into the connector. Your credentials are stored in the Qlik Web Connectors.

Loading data from tables

After you authenticate the connector with your account credentials, you can use tables such as the following to select and load data: 

Table Description
SubSites Fetches available sub sites from your Sharepoint account.
Lists Fetches available lists.
Groups Fetches available groups.
UsersInGroup Fetches available users in a group. You need the group ID to run this table.

Working with the Sharepoint 2013 REST API quota limits

The Qlik Web Connectors use the Sharepoint 2013 REST API to extract data from Office 365 Sharepoint and load it into your app. While reloading you Office 365 Sharepoint-based app, you might receive an error message that the connector has reached the Sharepoint 2013 REST 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.

You receive an error message that you have reached the API rate limit

Reference - Sharepoint 2013 REST API documentation

You can refer to the Sharepoint 2013 REST API documentation to learn more about the requirements and restriction imposed by the Sharepoint 2013 REST API.

Sharepoint 2013 REST 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 on Qlik Web Connectors by the Sharepoint 2013 REST API.

Proposed action  

To reduce the impact of reaching the API rate limits, develop your app with the following in mind:

  • Extract only the data you need.
  • Reload one Office 365 Sharepoint-based application at a time.
  • Ensure that loops in your script that make API calls will not result in infinite loops.

Did this information help you?

Can you tell us why it did not help you and how we can improve it?