Maybe use https://developer.yahoo.com/weather/ as a webservice. This is a REST service that is easily used from Mendix. Documentation can be found from within the modeler regarding the mapping and making of JSON structures. To get you started on the Mendix side you could look here.