Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rluciano1012
Contributor II
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
rbecher
MVP
MVP

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

Astrato.io Head of R&D

View solution in original post

3 Replies
rbecher
MVP
MVP

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

Astrato.io Head of R&D
rluciano1012
Contributor II
Contributor II
Author

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

Ross

Not applicable

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