topic Re: Load multiple lists from the SharePoint in Connectivity & Data Prep

Load multiple lists from the SharePoint

sudhakar_budde — Wed, 22 Dec 2021 14:43:52 GMT

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

Re: Load multiple lists from the SharePoint

Vu_Nguyen — Wed, 24 Apr 2019 14:58:22 GMT

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/ScriptSpecifiers/url.htm
REST connector: WITH CONNECTION - see https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Load-REST-data/Load-data.htm#WITH-CONNECTION-keyword

Re: Load multiple lists from the SharePoint

Arnauld — Mon, 01 Jul 2019 16:49:13 GMT

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={44a61de7-03f3-4738-a9df-a4b45fa4bf6c}

http://portail-odesca.intradef.gouv.fr/PIL/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={d040e86a-80ac-4f37-94b6-7b64d2a814b9}

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

Re: Load multiple lists from the SharePoint

Arnauld — Mon, 01 Jul 2019 16:57:28 GMT

I am using Qlik Sense it case it change something

Re: Load multiple lists from the SharePoint

Vu_Nguyen — Thu, 04 Jul 2019 09:14:13 GMT

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.

Re: Load multiple lists from the SharePoint

Arnauld — Thu, 04 Jul 2019 12:14:22 GMT

Thx you.

I added the script I used.