Skip to main content
Version: Streamsheets 3.0

OPENWEATHER.CURRENT.CITY

Premium

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

Syntax

=OPENWEATHER.CURRENT.CITY(City, [State], [Country], [Options], [ResponseTarget])

Arguments

NameTypeDescription
CityStringCity name to get current weather for
State (optional)StringState code in ISO 3166 format
Country (optional)StringCountry code in ISO 3166 format
Options (optional)JSONJSON containing parameters like mode, units or lang
ResponseTarget (optional)TargetSpecify inbox, outbox, cell or cell-range to write any response to

Return

TypeDescription
Boolean,Result,ErrorRequest result if no target is specified or TRUE. In case of an error the corresponding error-code is returned.

Examples

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

AB
1cityCologne
2unitsImperial