Skip to main content
Version: Streamsheets 2.4

OPENWEATHER.CURRENT

star This is a Streamsheets Enterprise feature.

Request current weather data for specified location.
Please refer to https://openweathermap.org/current for more information about available options (as of 2021-05-17).

caution

This function is currently under review.

Syntax

=OPENWEATHER.CURRENT(APIKey, CityOrJSON [, ResponseTarget])

Arguments

NameDescription
APIKeyA unique API key to authorize against openweather service
CityOrJSONJSON 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
1cityCologne
2unitsimperial
FunctionComment
=OPENWEATHER.CURRENT("123key","Cologn")Request current weather data for specfied city
=OPENWEATHER.CURRENT("123key",JSON(A1:B2))Same as before but using JSON to specify city and additionally set measurement units to imperial
AB
1cityId2172797
FunctionComment
=OPENWEATHER.CURRENT("123key",JSON(A1:B1))Using a city-id to specify a location
AB
1lat47.9959
2lon7.85222
3unitsmetric
FunctionComment
=OPENWEATHER.CURRENT("123key",JSON(A6:B8))Specify location by providing corresponding geographical coordinates and set measurement units to metric
AB
1lonLeft12
2latBottom32
3lonRight15
4latTop37
5zoom10
FunctionComment
=OPENWEATHER.CURRENT("123key",JSON(A10:B14))Providing a geographical bounding-box and zoom level to specify a region