Qlik Web Connector not fetching all data from SharePoint.

[Aryasmank]

Hi,

I'm fetching the SharePoint list through Qlik Web Connector. There are more than 5 rows in the list but the web connector only fetches 1 row. 

If anyone has any input please share.

Thanks,

Mayank

[Saurabh_K14999]

Hi,

Try checking if these are causing the issues -

1. The SharePoint list may be configured to only allow a single item to be displayed at a time. In this case, you will need to modify the list settings to allow multiple items to be displayed.

2. The Qlik Web Connector may be using a filter or query parameter that is limiting the results to a single row. You can check the configuration of the connector to see if any filters or query parameters have been specified.

Regards,

SK

[Aryasmank]

Hi,

Thanks for the response. 

Now after I cleared the cache of the web connector, all the data is visible under the " Data Preview" tab, but it is not fetching in qlik sense load script. Only one is fetching there. 

If you have any inputs please help.

Thanks.

[Aryasmank · Accepted solution]

Hi All,

The issue is resolved.

This is occurring due to the partial access that was provided to the Id I'm using.

After getting full access to the SharePoint list, now the data is fetching completely.

-Mayank