topic Need to load Data from URL in QlikView

Need to load Data from URL

Sun, 22 Jan 2017 17:09:40 GMT

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.

Re: Need to load Data from URL

maulajatt90 — Sun, 22 Jan 2017 18:11:20 GMT

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

Re: Need to load Data from URL

sreenivaskollur — Sun, 22 Jan 2017 20:10:27 GMT

Hi Harpreet,

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

Thank you!

Re: Need to load Data from URL

petter — Sun, 22 Jan 2017 20:35:00 GMT

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?