Sharepoint API in Qlik Sense

[dan_sullivan]

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.

[srm12213]

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.

Thanks

[srm12213]

Don't forget !

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.

• Re: QlikSense extensions makes system slow/hang?