topic "No Table Found in the HTML File" with web connection in Qlik Automate

"No Table Found in the HTML File" with web connection

hodgesjr0 — Wed, 07 Feb 2024 22:02:49 GMT

Hello. I am attempting to get the table from this URL:

https://index.goodcountry.org/

However, Qlik Sense gives me the "No Table Found in the HTML File" error. Does anyone know why?

Re: "No Table Found in the HTML File" with web connection

henrikalmen — Thu, 08 Feb 2024 09:56:12 GMT

Because there is actually no <table> in that file. The data you see on screen is rendered by javascript in your browser, and Qlik Sense can't read that.

Perhaps this json contains what you're looking for? https://index.goodcountry.org/data/1.5.json

Re: "No Table Found in the HTML File" with web connection

hodgesjr0 — Thu, 08 Feb 2024 15:40:47 GMT

Thank you! I can definitely work with a JSON.