Need to load Data from URL

[#1]

Hi Techics,

I have a requirement where i want to load the data from URL Https://www.xxxx.com in the qlikview script and then build a Dashboard in top of it.The URL contains the latest data and need authentiction while we connect with it.

Could you please guide me how we can acheive the same.

Thanks in advance.

[maulajatt90]

Hi Harpreet,

You can use the option reading webfiles :

It will generate the Script for reading data from the website:

Example:

Test:

LOAD @1 as Country,

     @2 as [1990],

     @3 as [1991],

     @4 as [1992],

     @5 as [1993],

     @6 as [1994],

     @7 as [1995]

FROM

[http://wdi.worldbank.org/table/1.1]

(html, codepage is 1252, no labels, table is @3);

Warm regards,
Maula

[sreenivaskollur]

Hi Harpreet,

This link could help you: how to pull data from URL which requires creden... | Qlik Community

Thank you!

[petter]

Could you please share some more details about the source data?

What kind of format is it? A standard-file format stored on an HTTP server? Do you need to parse basic HTML tables or is it an RSS-feed or can a REST-API be used?

What kind of authentication is used? Is your QlikView Server logged in with an account on Active Directory

Where is the server located? Is it a public server so it is not part of your organizations intranet?