Skip to main content
Version: Streamsheets 2.4

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).

caution

This function is currently under review.

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
ResponseTargetOptional. Specify inbox, outbox, cell or cell-range to write response to

Return Value

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.

Example

AB
1cityCologne
2limit2
3
4zipE14
5countryGB
FunctionComment
=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