How to Connect QlikSense to a 2013 SharePoint List

    ** Prerequisite – Install Qlik Sense REST Connector **


    1) Get guid from SharePoint list (Maybe your SP Administrator can provide this?)

    •    Navigate to the aspx page that contains the list:

         Example page: http://sharepoint/company/home/folder/project/new/newer/_formats/001/default.aspx

    • Click on the Site Contents link

    SharePointQlik00.png

    • Click on Settings

    SharePointQlik03.png

     

    • Doesn’t matter if you actually have permission to the object the Access Denied page has the information you need! Look at the URL and search the string from RIGHT to LEFT and find the first instance of the word “List” and copy everything from that point to the end of the URL. 

    AccessRequired.png

     

     

    Example url: http://sharepoint/company/home/folder/project/new/newer/_formats/001/AccessDenied.aspx?Source=http%3A%2F%2Fsharepoint%2Fcompany%2Fhome%2Ffolder%2Fproject%2Fnew%2Fnewer%2F_formats%2F001%2Flistedit%2Easpx%3FList%3DZY98XW76%252DVU54%252DTS32%252DRQ19%252DPO87NM65LK43


    • The %3D in the url encoding just means the equal sign (=) so it can be ignored. Change all “%2D” to “-“ (I used notepad)

    ReplaceHyphen.PNG

    • Wrap the result in curly brackets and you have the List ID

    Example GUID List ID = {ZY98XW76-VU54-TS32-RQ19-PO87NM65LK43}

     

    2) How to view xml code of a list view

    • Build URL: http://{0}/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={1}

     

              {0} – The URL to your site.  This could be the root web or a child site.

              {1} – The GUID for your list.

    Example URL for viewing XML in browser:

    http://sharepoint/company/home/folder/project/new/newer/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={ZY98XW76%252DVU54%252DTS32%252DRQ19%252DPO87NM65LK43}

     

    • Copy and paste the new url into your favorite browser and you should see a page of XLM. If you can't view the XML in a browser you won't be able to view it in QLIK so make sure you can see the information before continuing.

    HospSampleXML.PNG

     

    3) Open your QlikSense application and create a new connection using the "Qlik Rest Connector".

    CreateNewConnection_01.png

    4) Create new rest connection.

    • Enter the url you created in step 2.
    • Set the authentication and create a meaningful name (cnSharePointExampe)
    • Fill out the remaining options as follows and test the connection

    CreateNewConnection_02.png

    5) You can now load data (similar to any other data load process)

    SharePointLoadData.png

     

    ExampleDataFromXMLconnection.png