Skip to main content
Version: Streamsheets 3.0

OPENWEATHER.CURRENT

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(Lat, Lon, [Options], [ResponseTarget])

Arguments

NameTypeDescription
LatNumberLatitude value of geographical coordinates
LonNumberLongitude value of geographical coordinates
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(B1,B2, JSON(A3:B3))
Specify location by providing corresponding geographical coordinates and set measurement units to metric

AB
1lat47.9959
2lon7.85222
3unitsmetric