Qlik Community

Knowledge

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
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

Qlik Sense: Load a list from Sharepoint with Webfile connector

Sonja_Bauernfeind
Digital Support
Digital Support

Qlik Sense: Load a list from Sharepoint with Webfile connector

This article explains how to load a list from Sharepoint using the native Webfile connector in Qlik Sense and QlikView.

 

Environment:

Qlik Sense Enterprise on Windows 
QlikView 
Qlik Web Connectors 

 

  1.   Identify the GUID of the Sharepoint list. This can be done by:
    1. Open the List Settings page.
    2. GUID of the list can be found at the end of the page URL.
    3. Copy the last part of the URL after "...?List=" to a text editor and replace “%2D” to “-“ 

      guid.png

  2. Place the list GUID into the following URL: http://Server_Name/[sites/][Site_Name/]_vti_bin/owssvr.dll?Cmd=Display&List=GUID&XMLDATA=TRUE

    The final URL should look like the following: http://sharepoint/_vti_bin/owssvr.dll?Cmd=Display&List=0f40e3a1-bc9a-4800-9d6d-e58da228126d&XMLDATA=... 

  3.  Create a WebFile connection in QlikView/ Qlik Sense with the URL in step (2). The returned XML file contains 3 tables, among which list data is contained in table xml/data/row

    xml data row.png

  4. If the Web file connection cannot be created or fails to load, basic troubleshooting steps are as follows:
    1. On the server where QlikView/ Qlik Sense is installed, open a web browser with the service user or the user running Desktop application. Put the URL in step (2) in the address bar. Make sure that the XML file can be shown/downloaded directly without any authentication or redirection.
    2. Open Internet Options > Security > Local intranet > Custom level... > scroll to User Authentication > select option "Automatic logon with current username and password". Note that it's not always the Local Intranet zone. You can open the Sharepoint list in a browser, right click the page > Properties to understand which zone the page belongs to.
    3. For Qlik Sense only: Open file Settings.ini (C:\ProgramData\Qlik\Sense\Engine for Qlik Sense Enterprise, C:\Users\<Username>\Documents\Qlik\Sense\Settings.ini for Qlik Sense Desktop), add the following parameter: WebFileUnrestrictedAuth=1 and restart Qlik Sense Desktop/ Engine service. Make sure to backup the file before making any change.

 

 

Labels (1)
Version history
Revision #:
2 of 2
Last update:
‎2021-05-27 06:46 AM
Updated by:
 
Contributors