OPENWEATHER.GEO.COORDINATES
This is a premium 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
Name | Description |
---|---|
APIKey | A unique API key to authorize against openweather service |
TextOrJSON | A location name or JSON containing required and optional parameters |
ResponseTarget | Optional. 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
A | B | |
---|---|---|
1 | city | Cologne |
2 | limit | 2 |
3 | ||
4 | zip | E14 |
5 | country | GB |
Function | Comment |
---|---|
=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 |