Step by Step Instructions
Links provided in these examples are example links, not real links.
- Using a supported web browser, open up the Qlik Web Connectors Console
YourWebConnectorServer:5555/web
- Locate and click the Qlik Office 365 Sharepoint Connector
- Select the CanAuthenticate table in the available Tables list on the left.
- Click Parameters
- Copy your Sharepoint base URL (where the file is located) into the Base URL field
https://<yourO365TenantID>.sharepoint.com
- Click Authenticate
- This will open a new browser window with your Authentication Code. Copy the code to clipboard.
- Return to the previous browser window and paste the code into the Authentication Code field. Click Save.
- Now click Save Inputs & Run Table
A confirmation will be shown in the Data Preview tab reading true in the authenticated row.
- Locate the lists table in the Available Tables list on the left.
- Click Parameters
- Provide the Base URL and Sub Site Path
- Base URL: https://<yourO365TenantID>.sharepoint.com
- Optional include sub site Path: /sites/<yoursubsiteDirectoryPath>
- Click Save Inputs and Run Table
- The Connector will now attempt to preview the data
- Click the Qlik Sense (Standard Mode) tab
- Copy the URL provided:
http://localhost:5555/data?connectorID=Office365Connector&table=Lists&subSite=sites%2fstt&appID=
- Go to your app in Qlik Sense
-
And 'Create new connection' -> 'Web file', using URL: 'http://localhost:5555/' and give it a name.
-
Create a connection variable: let vQwcConnectionName = 'lib://Connection_name';
Environment
Related Content
How to load a file from SharePoint 365 using Qlik Using Qlik Web Connectors on premise
