topic Re: export/import using web link in Integration, Extension & APIs

export/import using web link

ghidalgo90 — Mon, 04 Oct 2021 21:30:24 GMT

Dear

Team

I am qlik user, one of our providers produce reports using qlik sense. Qlik give the option to produce "embed sheet"

I used excell that allow import data from web page to import above report using weblink . Using the follow steps::

1.Data / Import from web

2.. I this step I used the link provied by " "Embed sheet" / "iframe to embed in your web page"

3. Click in OK. Excell provide diferent ways to authenticate, I have tried all fo them, but not success. (I have user/pass of original web, where is produced the report)

I would like your help, to know how can I import the data in excell or power bi (the steps are the same).

Thanks for your support.

Re: export/import using web link

abhijitnalekar — Wed, 06 Oct 2021 14:28:39 GMT

Hi @ghidalgo90 ,

Like to ask you one doubt Are you looking to import chart in excel or data used in the chart?

Re: export/import using web link

ghidalgo90 — Wed, 06 Oct 2021 15:14:26 GMT

I want import the data in excell.

Thanks

Re: export/import using web link

abhijitnalekar — Wed, 06 Oct 2021 15:19:53 GMT

Unfortunately, the link which you are using in the excel is actually a link of the visualization, not data that's why Excel is not able to authorize the same.

Re: export/import using web link

ghidalgo90 — Wed, 06 Oct 2021 15:35:14 GMT

Can you let me know, in which way ca be generated the Link, to be readable from excell?

Thanks

Re: export/import using web link

abhijitnalekar — Thu, 07 Oct 2021 06:50:02 GMT

Hi @ghidalgo90 ,

There is no such direct link from which we can retrieve data from qliksense. but Yes we can achieve this using the Qliksense Capability API or the Engine API.

The below document surely helps you to understand the Qliksense API

http://help.qlik.com/en-US/sense-developer/3.2/Content/APIs-and-SDKs.htm