topic Re: Qlik Web Connector not fetching all data from SharePoint. in App Development

Qlik Web Connector not fetching all data from SharePoint.

Aryasmank — Mon, 19 Dec 2022 12:00:29 GMT

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

Re: Qlik Web Connector not fetching all data from SharePoint.

Saurabh_K14999 — Tue, 20 Dec 2022 10:38:13 GMT

Hi,

Try checking if these are causing the issues -

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.
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,

Re: Qlik Web Connector not fetching all data from SharePoint.

Aryasmank — Wed, 21 Dec 2022 12:57:43 GMT

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.

Re: Qlik Web Connector not fetching all data from SharePoint.

Aryasmank — Mon, 26 Dec 2022 14:05:44 GMT

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