Skip to main content
Version: Streamsheets 2.4

OPENWEATHER.ONECALL

star This is a Streamsheets Enterprise 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).

caution

This function is currently under review.

Syntax

=OPENWEATHER.ONECALL(APIKey, JSON [, ResponseTarget])

Arguments

NameDescription
APIKeyA unique API key to authorize against openweather service
JSONJSON containing required and optional parametes
ResponseTargetOptional. Specify inbox, outbox, cell or cell-range to write any response to

Return Value

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.

Example

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