topic [Qlik Sense Cloud] Load HTML code from a webpage in App Development

[Qlik Sense Cloud] Load HTML code from a webpage

André — Mon, 13 May 2024 23:35:22 GMT

How do I load the HTML code from a website to a table? I saw the following script provided in another older thread, but I get an error when trying to run it.

html:

LOAD RecNo() as Rec,

@1:n as Line

FROM [https://www.google.com/index.html]

(fix, utf8)

;

NoConcatenate

html1:

Load

Where Line <> '>'

;

Load

RecNo() as Rec,

subfield(Line,'>') & '>' as Line

Resident html

Order By Rec

;

NoConcatenate

html2:

Load

Where left(Line, 1) <> '<' and len(trim(Line))>0

;

Load

Rec,

if(Right(Line,1)='>' and Left(Line, 1) <> '<', '</' & Line, Line) as Line

;

Load

Rec,

subfield(Line,'</') as Line

Resident html1

Order By Rec;

drop tables html, html1;

Any solutions to read a web page to table? I note that the docs on the Load advise loading from a webpage is possible?

Re: [Qlik Sense Cloud] Load HTML code from a webpage

André — Thu, 16 May 2024 03:01:40 GMT

Bump

Re: [Qlik Sense Cloud] Load HTML code from a webpage

tvolkmerwolf — Tue, 18 Jun 2024 09:46:50 GMT

Hi André,

just stumbled across the same question and found this one:

Solved: How to connect with web file (SaaS and Client Mana... - Qlik Community - 1858684

See the remark from DLopeze where he states that he/she found another way.

Hope this helps!