This is a Streamsheets Enterprise feature.
Request weather data, current and forecast, for specified location.
Please refer to https://openweathermap.org/api/one-call-api for more information about available options (as of 2021-05-17).
This function is currently under review.
=OPENWEATHER.ONECALL(APIKey, JSON [, ResponseTarget])
|APIKey||A unique API key to authorize against openweather service|
|JSON||JSON containing required and optional parametes|
|ResponseTarget||Optional. Specify inbox, outbox, cell or cell-range to write any response to|
|=OPENWEATHER.ONECALL("123key",JSON(A1:B2))||Request weather data for specfied geographical coordinates|
|=OPENWEATHER.ONECALL("123key",JSON(A1:B4))||Same but exclude hourly and minutely forecast and additionally set measurement units to imperial|