Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.


Load multiple lists from the SharePoint

Hi Experts,

I have a requirement to extract data from multiple lists from SharePoint .

At the moment I am creating a separate data connection for each list and it works fine, but the number of data connections is growing and it is hard to maintain in the long run as it continues to grow! 

As there are number of lists to be extracted SharePoint, is there any method that simply load all the lists with small script and to avoid the creation of multiple data connections please?

Can any one help me on this please?





1 Reply

Re: Load multiple lists from the SharePoint


If you are loading Sharepoint lists using REST connector or webfile connector in Qlik Sense, you can create only one connection, then change URLs to the lists dynamically during script execution using the following keywords:

Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.