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

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

	A	B
1	city	Cologne
2	limit	2
3
4	zip	E14
5	country	GB

Formula	Result	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