The Openweather Integration allows you to access the Openweather API from a Streamsheet. Integration Functions always base on an Integration Account. Create a Openweather account and set up an API Key
Openweather Integration Settings
The Openweather API Key is stored in the Integration Settings. Create a new Integration Account and select Openweather.
The predefined URLs are base URLs and point to the current API endpoints. Only change them, if the API endpoints change. Enter an API key to your account. This account can now be linked to every Streamsheet.
Open an App and select the Integration menu in the top right toolbar, next to the connections. Choose Openweather and select your just created account. Now you are able to use the OPENWEATHER.() functions. To get a headstart use the Openweather template.
Screenshot shows the requesting of geo coordinates for the city Berlin, to than be used to query historical air pollution data form the last 24 hours.