OPENWEATHER.GEO.COORDINATES.ZIP
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.ZIP(Zip, [Country], [ResponseTarget])
Arguments
| Name | Type | Description |
|---|---|---|
| Zip | String | Zip code of the location to get geographical coordinates for |
| Country (optional) | String | Country code in ISO 3166 format |
| 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 by providing a zip code and country |