OPENWEATHER.ONECALL
Premium
Request weather data, current and forecast, for specified location. Please refer to one call API for more information about available options (as of 2021-05-17).
Syntax
=OPENWEATHER.ONECALL(Lat, Lon, [Options], [ResponseTarget])
Arguments
| Name | Type | Description |
|---|---|---|
| Lat | Number | Latitude value of geographical coordinates |
| Lon | Number | Longitude value of geographical coordinates |
| Options (optional) | JSON | JSON containing parameters like exclude, units or lang |
| ResponseTarget (optional) | Target | Specify inbox, outbox, cell or cell-range to write any response to |
Return
| Type | Description |
|---|---|
| Boolean,Result,Error | Request result if no target is specified or TRUE. 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 |