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.
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.
3) Open your QlikSense application and create a new connection using the "Qlik Rest Connector".
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
5) You can now load data (similar to any other data load process)
I wrote the documentation above based on Qlik Sense 3.2. After I created the documentation we "upgraded" our development to Feb 2018 but unfortunately I can no longer create apps or make data connections so it is hard to update the documentation. We have a support case open for that issue but in the meantime I can make a guess as to the issue.
I suspect your primary issue is building out the URL. Are you able to view the XML in your brower (step 2)? If not, get that part working before you try to make a connection to the sharepoint data.
Do you get the 403 error from Qlik or from a browser when navigating to the derived XML url?
I was able to create connection with the "Window NTLS" option but I had to supply a login which is not what you. Since I was not able to get Windows Authentication to work on Feb 2018, I edited the connection string in the QMC. This produced an error during the load that the "connection format is obsolete".
I am still getting the 403 Error. I am plugging the admin username and password !. and Using the browser when I push the link I am getting download .DLL file I click yes and I open the DLL as XML it opens Up
Your XML looks good but when I enter my URL, my XML renders immediately. I don’t have to click “yes”. Can send a screenshot of that dialog box? Were you on your personal computer when you took the XML screenshot or were you remoted into the Qlik application server? Might also check and make sure your SharePoint site doesn’t have any IP deny rules blocking the Qlik Application Server? Are you using Qlik Sense Desktop or Enterprise?
I am using Qlik Sense Desktop but I have Qlik Sense Server. I was on my personal computer. I am able to see the sharepoint from my browser and administer it normally .. So I suppose there is no permission access thing