Qlik Community


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

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Qlik Sense: Load a list from Sharepoint with Webfile connector

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.



Qlik Sense Enterprise on Windows 
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 “-“ 


  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
Last update:
‎2021-05-27 06:46 AM
Updated by: