Python-Code

""" weather api call """ 

import urllib2

city_name ='Hamburg'
# api = '' >> Has to be defined.
response = urllib2.urlopen('http://api.openweathermap.org/data/2.5/weather?q=%s&APPID=%s' % (city_name.lower(), api_key))
test_data = eval(response.read())

# parse input data to readable dict:
data = {}
data['lon'] = test_data['coord']['lon'] 
data['lat'] = test_data['coord']['lat']
data['weather_description'] = test_data['weather'][0]['description']
data['name'] = test_data['name']
data['windspeed'] = test_data['wind']['speed']
data['temperatur'] = test_data['main']['temp'] - 273.15
data['pressure'] = test_data['main']['pressure']

# return data as a string
print('In %(name)s, koords (%(lon)s,%(lat)s) ist die Temperatur bei %(temperatur)s Grad Celsius.\nDie Windgeschwindigkeit betraegt %(windspeed)f.\nDas Wetter is %(weather_description)s.\nDer Luftdruck ist bei %(pressure)s.' % data  )

# to have a valid etl process, write this to a datawarehouse.