Skip to main content
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Sharepoint API in Qlik Sense

I am able to connect to a SharePoint list using this URL in my QlikRestConnector

https://company/site/subsite/_api/lists/getbytitle('Market Research Project Tracker')/items?$top=100000

I then can navigate through all the folders the API creates to select the data and tables that I want.  Problem is that some of my fields are 'choice' fields in the SharePoint list.  Some of these pull in the choice values (see SBU in 2nd pic) while others do not (see Service Line in 2nd pic). I'm guessing this is more of a SharePoint API problem than it is in Qlik, but wanted to see if anyone has ran into this before.

Screen Shot 2018-07-27 at 12.35.47 PM.png

Screen Shot 2018-07-27 at 12.38.50 PM.png

2 Replies
Contributor III
Contributor III

Hi Dan,

To check whether it is a Qlik issue or Sharepoint. I suggest you to use POSTMAN and connect to the SharePoint URL and try fetch the same data. Please read the SharePoint documentaion or check the Configuration document to find out the difference between the SBU and Service_x0020_Line.

I am thinking that "Service_x0020_line" has restriction on SharePoint end or it is not queryable/readable. 

I holpe this help's you.


Contributor III
Contributor III

Don't forget !

When applicable please mark the appropriate replies as CORRECT This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.