OPENWEATHER.CURRENT.CITY
Premium
Request current weather data for specified location. Please refer to [current API] (https://openweathermap.org/current) for more information about available options (as of 2021-05-17).
Syntax
=OPENWEATHER.CURRENT.CITY(City, [State], [Country], [Options], [ResponseTarget])
Arguments
| Name | Type | Description | 
|---|---|---|
| City | String | City name to get current weather for | 
| State (optional) | String | State code in ISO 3166 format | 
| Country (optional) | String | Country code in ISO 3166 format | 
| Options (optional) | JSON | JSON containing parameters like mode, units or lang | 
| ResponseTarget (optional) | Target | Specify inbox, outbox, cell or cell-range to write any 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
| Formula | Result | Comment | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
 | Request current weather data for specified city | ||||||||||
 | Same as before but using JSON to specify city and additionally set measurement units to imperial
  |