Obtain Weather Data via API Call

• SQL_Jim

  Old Hand

  Points: 328

  More actions

  May 13, 2016 at 1:02 am

  #74538

  Hi there,

  I work for a retail company, in a small team who look after all the reporting using SQL Server 2008R2 and SSRS.

  Our bosses have requested to see weather data: temperature / rainfall, it's an open ended request, they don't really know what they want. The problem is that my knowledge is limited to querying SQL Server. I suspect I need to call an API and get the data into our SQL Server somehow.

  I'm willing to learn all this, I just don't know where to begin. I just need a steer.

  Could someone please advise me on what I need to learn to be able to do all this stuff? API calls, etc.

  Thanks for reading,

  Jim

• ram302

  SSCommitted

  Points: 1618

  More actions

  May 27, 2016 at 8:02 am

  #1881792

  Some web development may be required. And/or maybe some local scripts to pull the data from the API. Here's one I found with a quick search on Bing: http://openweathermap.org/API.

  My personal experience has been with PHP, and this could be done in PHP. Also, will you want to store this data in your DB?

• crk5070

  SSC-Addicted

  Points: 452

  More actions

  June 2, 2016 at 8:24 am

  #1882829

  Someone did this with an SSIS script.

  http://www.codeproject.com/Articles/679706/Weather-Scraper-to-Get-Weather

  Bear in mind this was from 2013, so the API may have changed since then.

• SQL_Jim

  Old Hand

  Points: 328

  More actions

  June 2, 2016 at 12:29 pm

  #1882896

  Oh cool, thanks for the advice. I'll have go at that.