Skip to main content
Version: Streamsheets 2.5

OPENWEATHER.GEO.COORDINATES

star This is a Streamsheets Enterprise feature.

Converts a location specified by name or zip/post code into geographical coordinates. Please refer to https://openweathermap.org/api/geocoding-api for more information about available options (as of 2021-05-17).

Syntax

=OPENWEATHER.GEO.COORDINATES(APIKey, TextOrJSON, [ResponseTarget])

Arguments

NameDescription
APIKeyA unique API key to authorize against openweather service
TextOrJSONA location name or JSON containing required 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
1cityCologne
2limit2
3
4zipE14
5countryGB
FormulaResultComment
=OPENWEATHER.GEO.COORDINATES("123key","Cologne")
Resolve geo coordinates for specified city
=OPENWEATHER.GEO.COORDINATES("123key",JSON(A1:B2))
Same as before but using JSON to specify city name and set result limit to 2
=OPENWEATHER.GEO.COORDINATES("123key",JSON(A4:B5))
Resolve geo coordinates by providing a zip code and country