weatherdatagrab
Richard_Rowe
2025-03-23
Extract 3 sets of data from 2 different sources to obtain weather and tide data for a Tableau dashboard
Licence for data sources are given at end of document.
- Extract a current forcast for a location from open-meteo.com
- Extract a 7 day forecast for a location from open-meteo.com
- Extact tidal information for a location from UK Hydrographic office
The 3 csv files can then be fed into a Tablea dashboard.
These API requests can be set to run automaticaly by creating a script file with the code chunks and then running it automatically in windows scheduler to obtain fresh data as required.