topic Re: Qlik Web Connector in Connectivity & Data Prep

Qlik Web Connector

ritvik4BI — Fri, 02 Apr 2021 09:06:27 GMT

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?????

Re: Qlik Web Connector

stevedark — Tue, 15 Dec 2020 08:50:08 GMT

Hi @ritvik4BI

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

Steve

Re: Qlik Web Connector

ritvik4BI — Wed, 16 Dec 2020 08:23:19 GMT

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.

Re: Qlik Web Connector

stevedark — Wed, 30 Dec 2020 11:14:00 GMT

Hi @ritvik4BI

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

Steve