OPENWEATHER.GEO.COORDINATES
Premium
Converts a location specified by name or zip/post code into geographical coordinates. Please refer to geocoding API for more information about available options (as of 2021-05-17).
Syntax
=OPENWEATHER.GEO.COORDINATES(City, [State], [Country], [Limit], [ResponseTarget])
Arguments
| Name | Type | Description |
|---|---|---|
| City | String | City name to get geographical coordinates for |
| State (optional) | String | State code in ISO 3166 format |
| Country (optional) | String | Country code in ISO 3166 format |
| Limit (optional) | Number | Limits the number of locations in response. Max limit is 5. |
| ResponseTarget (optional) | Target | Specify inbox, outbox, cell or cell-range to write response to |
Return
| Type | Description |
|---|---|
| Boolean,Result,Error | Request result if no target is specified or TRUE. In case of an error the corresponding error-code is returned. |
Examples
| A | B | |
|---|---|---|
| 1 | city | Cologne |
| 2 | limit | 2 |
| 3 | ||
| 4 | zip | E14 |
| 5 | country | GB |
| Formula | Result | Comment |
|---|---|---|
| Resolve geo coordinates for specified city | |
| Same as before but using JSON to specify city name and set result limit to 2 |