I have moved this to the Web Data Connector section of the Tableau Community. There is a better chance someone here vs. the regular discussion forum can assist with your scenario.
For doing analysis on weather I would check the below blog post about using a WDC to make calls to the OpenWeatherMap API. The WDC is even made available by the author, Alex Ross.
Hope this helps!