Load multiple lists from the SharePoint

[sudhakar_budde]

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?

Thanks

SB

[Vu_Nguyen]

Hi,

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:

• Webfile connector: URL is - see https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpec...
•  REST connector: WITH CONNECTION - see https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Load-R...

[Arnauld]

Hello,

I am interested to really understand what to do. Unfortunatly the link about REST and within connection is not enough to my comprehension.

Could you explain a bit more with a full code inspired by those elements :

I am using a REST connection to get lists on a SHP 2013. I use the GUID to do thay like those followings codes (as I am in an intranet I give you the all URL)

http://portail-odesca.intradef.gouv.fr/PIL/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List...}

http://portail-odesca.intradef.gouv.fr/PIL/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List...}

So If I could have a way to not set the part between{} in the connection but in the script as a parma file maybe it could be perfect. But I don't understand how to do that (if it's possible)

Thx

[Arnauld]

I am using Qlik Sense it case it change something

[Vu_Nguyen]

Hi, please check the following articles:

• Load a list from Sharepoint with Webfile connector: https://support.qlik.com/articles/000041437
• Load a list from Sharepoint with the REST Connector: https://support.qlik.com/articles/000031498

Hope these help.

[Arnauld]

Thx you.

I added the script I used.