Qlik Web Connector

[ritvik4BI]

 Question: How to load multiple excel files from SharePoint to Qlik Sense using Qlik Web Connector?

I have a module Sales in SharePoint.  It has 10 excel files. Now in order to create connection string for these 10  files in Qlik Sense what I am currently doing is 

From the ListFiles I get all 10 files with their unique ids and name. And now I am creating a connection string for each unique Id which generates a different Url for qlik sense one by one..

I have modules in SharePoint which are as big as 100 files or even more. I want that instead of wasting so many man hours on creating connection string for each file individually..  How can I load multiple excel files from SharePoint to Qlik Sense in one go?????

[stevedark]

Hi @ritvik4BI 

Have a look at the WITH CONNECTION statement. This allows you to inject parts of the URL with variables. 

Steve

[ritvik4BI]

Hi @stevedark 

Can you give me some link/reference. I have no idea on how use the WITH CONNECTION statement to be able to inject parts of the URL with variables...

Thanks. 

[stevedark]

Hi @ritvik4BI 

I would try starting here:
https://community.qlik.com/t5/Qlik-Design-Blog/REST-connector-Using-WITH-CONNECTION/ba-p/1523257

Steve