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 REST API quota limits

The Qlik Web Connectors use the Sharepoint 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 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 REST API documentation

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

Sharepoint REST service

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 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?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

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