Version: Streamsheets 2.5

OPENWEATHER.CURRENT

This is a premium 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

Name	Description
APIKey	A unique API key to authorize against openweather service
CityOrJSON	JSON 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

Formula Result Comment

=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

	A	B
1	city	Cologne
2	units	Imperial

=OPENWEATHER.CURRENT("123key",JSON(A1:B1))

Using a city-id to specify a location

	A	B
1	cityId	2172797

=OPENWEATHER.CURRENT("123key",JSON(A1:B3))

Specify location by providing corresponding geographical coordinates and set measurement units to metric

	A	B
1	lat	47.9959
2	lon	7.85222
3	units	metric

=OPENWEATHER.CURRENT("123key",JSON(A1:B5))

Providing a geographical bounding-box and zoom level to specify a region

	A	B
1	lonLeft	12
2	latBottom	32
3	lonRight	15
4	latTop	37
5	zoom	10