OPENWEATHER.ONECALL
This is a premium feature.
Request weather data, current and forecast, for specified location. Please refer to https://openweathermap.org/api/one-call-api for more information about available options (as of 2021-05-17).
Syntax
=OPENWEATHER.ONECALL(APIKey, JSON, [ResponseTarget])
Arguments
| Name | Description |
|---|---|
| APIKey | A unique API key to authorize against openweather service |
| JSON | JSON containing required and optional parameters |
| ResponseTarget (optional) | Specify inbox, outbox, cell or cell-range to write any response to |
Return
A unique random request ID which can be used with REQUESTINFO to check the state of the request. In case of an error the corresponding error-code is returned.
Examples
| A | B | |
|---|---|---|
| 1 | lat | 50.38 |
| 2 | lon | 6.57 |
| 3 | exclude | hourly, minutely |
| 4 | units | imperial |
| Formula | Result | Comment |
|---|---|---|
| Request weather data for specified geographical coordinates | |
| Same but exclude hourly and minutely forecast and additionally set measurement units to imperial |