Skip to main content
Version: Streamsheets 2.5

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).

Syntax

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

Arguments

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

FormulaResultComment
=OPENWEATHER.CURRENT("123key","Cologne")
Request current weather data for specified city
=OPENWEATHER.CURRENT("123key",JSON(A1:B2))
Same as before but using JSON to specify city and additionally set measurement units to imperial

AB
1cityCologne
2unitsImperial
=OPENWEATHER.CURRENT("123key",JSON(A1:B1))
Using a city-id to specify a location

AB
1cityId2172797
=OPENWEATHER.CURRENT("123key",JSON(A1:B3))
Specify location by providing corresponding geographical coordinates and set measurement units to metric

AB
1lat47.9959
2lon7.85222
3unitsmetric
=OPENWEATHER.CURRENT("123key",JSON(A1:B5))
Providing a geographical bounding-box and zoom level to specify a region

AB
1lonLeft12
2latBottom32
3lonRight15
4latTop37
5zoom10