Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

skyline01
New Contributor

connect Qlik Sense to a 2013 SharePoint list

I am having an issue connecting Qlik Sense to a 2013 SharePoint list.  I have followed all of the steps as described in this post:

How to Connect QlikSense to a 2013 SharePoint List

I am able to view the list's XML in a browser.  However, when I test my REST connection in Qlik Sense, I get the following error:

HTTP protocol error 403 (FORBIDDEN): The server refused to fulfill the request.

I asked my SharePoint administrator about this, and he said that it's happening because REST requests do not support Forms Based Authentication (FBA), which means that a new end point will need to be created.  However, I see nothing in the above link (or other posts like it) that discuss anything about FBA.  So, is it likely that the connection is failing because of lack of support for FBA?  Or, is it most likely something else?

Tags (1)
2 Replies
rachel_delany
Contributor

Re: connect Qlik Sense to a 2013 SharePoint list

Hi Casey,

Have you tried entering in your authentication details, rather than using Windows authentication? E.g. in Step 4 choose Windows Authentication: No, which will allow you to enter in credentials.

This worked for me.

skyline01
New Contributor

Re: connect Qlik Sense to a 2013 SharePoint list

Hi Rachel,

To be clear, I'm using Qlik Sense Enterprise February 2018 initial release.  As the author of that article (@William Christensen) noted in his question at the end of that posting, the authentication options are different in this release (relative to 3.2).  Below are the new authentication options:

REST1.png

REST2.png

We use Windows authentication for nearly everything at my workplace (including Qlik Sense and SharePoint sites).  So, it would seem reasonable to choose 'Windows NTLM' or 'Current Windows User (NTLM)'.  It turns out that option 'Current Windows User (NTLM)' is only supported for Qlik Sense Desktop.  So, the best match is probably 'Windows NTLM'.  I have tried supplying my Windows credentials in that option, as well as in options 'Basic' and 'Digest'.  (Anonymous doesn't accept credentials.)  None of them work, even when I specify my AD domain.

The author of that article did post a question himself about the lack of the Windows authentication option:

Rest Connection with Windows Authentication qlik sense ENTERPRISE feb 2018

...to which he noted in his original posting that he ended up using a service account.  That may be the solution in my scenario as well, but I first want to be sure that it has nothing to do with what my SharePoint admin said about REST and FBA.

Community Browser