topic Re: Reading from other website in QlikView

Reading from other website

bkkuah17 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Everybody !

I am new to Qlikview. While exploring Qlikview functional, i notice a interesting feature - extract from web file. Some website does managed to be extracted by qlikview while others not for example, http://www.bursamalaysia.com/market/securities/equities/prices/#/?filter=BS02 . Can anyone elaborate on this ? Thanks

Cheers !

Re: Reading from other website

Anil_Babu_Samineni — Fri, 16 Sep 2016 15:36:15 GMT

What is your question?

Re: Reading from other website

bkkuah17 — Sat, 17 Sep 2016 00:20:42 GMT

Why can't web extract data from this page, http://www.bursamalaysia.com/market/securities/equities/prices/#/?filter=BS02

Re: Reading from other website

marcus_sommer — Sat, 17 Sep 2016 10:49:59 GMT

Qlik can read data from websites which are included in (standard) tables like HTML Tables. Another possibility is the use of a specific connector - take a look on this: https://community.qlik.com/search.jspa?q=rest+connector&type=document.

- Marcus

Re: Reading from other website

bkkuah17 — Sun, 18 Sep 2016 03:06:46 GMT

If my understanding is correct Qlikview web pages can extract only direct hard-coded html tables

if html contain javascript generated table then it will not be able to extract data from javascript generated tables.

Re: Reading from other website

marcus_sommer — Mon, 19 Sep 2016 05:00:45 GMT

I'm not absolutely sure about it but yes I think that if the content will be created dynamically per javascript it won't work. If you don't need to query this website regular it might be an alternatively to store the site and/or doing a manually copy from the content. If it must be dynamically then you need to look if there is any API available (which then might be commercial).

- Marcus