Qlik Community

Ask a Question

Knowledge Base

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER

How to load a file from SharePoint 365 using Qlik Using Qlik Web Connectors

Sonja_Bauernfeind
Digital Support
Digital Support

How to load a file from SharePoint 365 using Qlik Using Qlik Web Connectors


In this example, we load data from an Excel file hosted on SharePoint 365 using the Qlik Office 365 Sharepoint connector.

Environment:

Qlik Web Connectors: Qlik Office 365 SharePoint Connector
All Qlik Sense Enterprise on Windows 

 

For our example, we are using Qlik Sense Enterprise on Windows and the installed Qlik Web Connector for Office 365 Sharepoint. For more information on the Office 365 Sharepoint Qlik Web Connectors and for installation instructions, see: Office 365 Sharepoint and Installation Web Connectors.

 

Step by Step Instructions (as seen in the video)

Links provided in these examples are example links, not real links. 

  1. Using a supported web browser, open up the Qlik Web Connectors Console
    YourWebConnectorServer:5555/web
  2. Locate and click the Qlik Office 365 Sharepoint Connector
  3. Select the CanAuthenticate table in the available Tables list on the left.
  4. Click Parameters
  5. Copy your Sharepoint base URL (where the file is located) into the Base URL field
    https://<yourO365TenantID>.sharepoint.com
  6. Click Authenticate
  7. This will open a new browser window with your Authentication Code. Copy the code to clipboard. 
  8. Return to the previous browser window and paste the code into the Authentication Code field. Click Save.
  9. Now click Save Inputs & Run Table
    A confirmation will be shown in the Data Preview tab reading true in the authenticated row.
  10. Locate the ListFolders table in the available Tables list on the left.
  11. Click Parameters 
  12.  Provide the Base URL and Sub Site Path
    • Base URL: https://<yourO365TenantID>.sharepoint.com
    • Sub site Path: /sites/<yoursubsiteDirectoryPath>
  13. Click Save Inputs and Run Table
  14. In the now available list, locate the directory your file is located in.
  15. Copy the path and paste it into the Folder field.
  16. /sites/<yoursubsiteDirectoryPath>/Shared Documents/Functional Area - Development
  17. Repeat this step if needed to continue listing nested folders until you locate the folder storing the file. 
  18. Click Save Inputs and Run Table
  19. Copy the folder ServerRelativeUrl
  20. Locate the ListFiles table in the available Tables list on the left. This will allow us to identify the ID of the Excel file.
  21. Click Parameters 
  22. Paste the ServerRelativeUrl into the Folder field
  23. Click Save Inputs and Run Table
  24. The Data Preview tab will now show us the UniqueId of the xslx document you are interested in. In our example: cf079b74-1bc8-4a5a-971d-07321081a6ac
  25. Copy the ID
  26. Go back and choose the GetFile table
  27.  The Sub Site path should be the subsite that you have previously used
  28. Paste the UniqueId into the UniqueId For File field.
  29. Click Save Inputs and Run Table
  30. The Connector will now attempt to preview the data
  31. Click the Qlik Sense (Standard Mode) tab
  32. Copy the URL provided:
    http://localhost:5555/data?connectorID=Office365Connector&table=GetFile&subSite=%2fsites%2f<yoursubsiteDirectoryPath>&fileId=cf079b74-1bc8-4a5a-971d-07321081a6ac&appID=
  33. Go to your app in Qlik Sense
  34. Create a connection to a web file using that URL previously copied.
  35. Reload the data to your Sense app
Labels (2)
Comments
qs123
Contributor II
Contributor II

Hi, Thank you for the detailed post. The connector was working fine for us but it broke few months ago. Now we have upgrade Qlik to September 2020 and the webconnector to the latest release as well.

We are trying to access an excel for which the user already able to access on share point. The authentication is working fine

 

qs123_0-1607532740558.png

 

 

but it throws an error getting sub-site

 

qs123_1-1607532787785.png

 

 

What could be the reason for this?

 

Thank you

 

gkkandukuri
Contributor
Contributor

hi,

we are using Feb 2020 and when trying to authenticate, it is opening a new tab and asking to enter login and password. which after entering it is asking again to re enter.

 

Please advise

Francisco_Fernandez

Hello @qs123 ,

Usually, a "no rows returns" means that probably the resource that you are trying to access. I would suggest verifying on SharePoint if that subsite is accessible.


Hello @gkkandukuri ,

Please note Feb2020 version does not exist in QWC, I would suggest using December 2020 version and check if the issue persists.

As a side note, I would recommend requesting assistance in our community (creating a post) to make sure that your questions get answered, our active users and engineers are constantly monitoring these boards.

For this specific topic, the Qlik Connector forum is the best-suited location to get your answers soon!

Best regards,

Francisco

Version history
Revision #:
5 of 5
Last update:
‎2020-11-17 03:33 AM
Updated by:
 
Contributors