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!
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.