Skip to main content
Version: Streamsheets 2.5

OPENWEATHER.GEO.REVERSE

star This is a Streamsheets Enterprise feature.

Converts a geographical location into names of nearby locations. Please refer to https://openweathermap.org/api/geocoding-api for more information about available options (as of 2021-05-17).

Syntax

=OPENWEATHER.GEO.REVERSE(APIKey, JSON, [ResponseTarget])

Arguments

NameDescription
APIKeyA unique API key to authorize against openweather service
JSONJSON containing geographical location to convert and optional parameters
ResponseTarget (optional)Specify inbox, outbox, cell or cell-range to write 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

AB
1lat50.38
2lon6.57
3limit2
FormulaResultComment
=OPENWEATHER.GEO.REVERSE("123key",JSON(A1:B3))
Request name of specified geographical location and limit result of possible names to 2