Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

rluciano1012
New Contributor II

How can I pull in historical weather data into a QlikView model using Weather Underground's Weather API?

Can anyone help me?  I would like to pull in historical and forecast weather data into a QlikView model using Weather Underground's Weather API.  I'm not really a programmer, so not exactly sure how to do it in a QlikView load script, but it looks like it's possible.  I think for a programmer, it would be fairly easy.  They have a free account sign-up located at http://www.wunderground.com/weather/api/ and I have registered so I have my own key I can insert into the code. I'm fairly experienced creating load script from databases and Excel files, but never have done anything pulling from an external source.

For example, I would like to pull in historical weather data for several cities or a table of cities I could choose from.  For this example say I want Lexington, KY, Denver, CO and Green Bay, WI.  In addition to historical, would be really cool to bring in current conditions and forecast, although I think it would be easier for me to follow if each were separate Loads within the script.  I believe all of those are options by looking at the site.

I will greatly appreciate any help from all you expert programmers out there!

Ross

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: How can I pull in historical weather data into a QlikView model using Weather Underground's Weather API?

Hi Ross,

just enter the URL as a web file and choose XML as format:

http://api.wunderground.com/api/<your API key>/history_20111020/q/KY/Lexington.xml

- Ralf

3 Replies
MVP & Luminary
MVP & Luminary

Re: How can I pull in historical weather data into a QlikView model using Weather Underground's Weather API?

Hi Ross,

just enter the URL as a web file and choose XML as format:

http://api.wunderground.com/api/<your API key>/history_20111020/q/KY/Lexington.xml

- Ralf

rluciano1012
New Contributor II

How can I pull in historical weather data into a QlikView model using Weather Underground's Weather API?

Thanks Ralf!  It's working and I have modified it to bring in additional information.  Thanks for your help!

Ross

Not applicable

Re: How can I pull in historical weather data into a QlikView model using Weather Underground's Weather API?

hi does anyone know how to make the link dynamic because I would like to pull everyday the history data from yesterday so I would love to make his dynamic but I always get the error that the link could not be found.

can someone please help me

regards,

MT

Community Browser