Qlik Community

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE

Web Connectors Sharepoint O365 - Select items/views from a list

armandfrigo
Luminary Alumni
Luminary Alumni

Web Connectors Sharepoint O365 - Select items/views from a list

Hi,

Within the Web Connectors Sharepoint O365, we would greatly appreciate an option to select a list of items or a view from a Sharepoint list.

As of today, we cannot retrieve the data in case of many recursive lookups within items.

We would be able to extract data from such a list if we could restrict the request to a limited number of items or if we could target a list view. 

2021-04-21_10-07-46.png

There is a setting in Sharepoint, but unfortunately that view has too many items with too many lookups, so we cannot extract its data.

2021-04-21_10-08-00.png

If we make an API call and do not specify any columns, we face the very same error:

https://share.company.net/sites/WriteOffApproval/_api/lists/getbytitle('WriteoffRequest')/items

2021-04-21_10-14-47.png

However, if we restrict the number of colums then it works just fine.

https://share.company.net/sites/WriteOffApproval/_api/lists/getbytitle('WriteoffRequest')/items?$sel...

 

Tags (2)
3 Comments
Carl_Hunter
Partner - Creator III
Partner - Creator III

Is this a bug @armandfrigo ? Might be worth raising with Qlik Support 

armandfrigo
Luminary Alumni
Luminary Alumni

I wish it was a bug, so we could get support, but it's not.

This requires an additional option with that connector. 

P-O_Davidson
Employee
Employee

The development team is currently working on this. It is targeted to be added in Qlik Sense SaaS by June 2022, and to be included in Qlik Sense Enterprise on Windows in the August 2022 release.

Status changed to: Open - In Development