Skip to main content
Version: Streamsheets 2.5

OPENWEATHER.ONECALL

star 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

NameDescription
APIKeyA unique API key to authorize against openweather service
JSONJSON 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

AB
1lat50.38
2lon6.57
3excludehourly, minutely
4unitsimperial
FormulaResultComment
=OPENWEATHER.ONECALL("123key",JSON(A1:B2))
Request weather data for specified geographical coordinates
=OPENWEATHER.ONECALL("123key",JSON(A1:B4))
Same but exclude hourly and minutely forecast and additionally set measurement units to imperial