Skip to main content
Version: Streamsheets 2.4

OPENWEATHER.AIRPOLLUTION.HISTORICAL

star This is a Streamsheets Enterprise feature.

Request historical air pollution data for specified location.
Please refer to https://openweathermap.org/api/air-pollution for more information about available options (as of 2021-05-17).

caution

This function is currently under review.

Syntax

=OPENWEATHER.AIRPOLLUTION.HISTORICAL(APIKey, JSON [, ResponseTarget])

Arguments

NameDescription
APIKeyA unique API key to authorize against openweather service
JSONJSON containing geographical coordinates and start- and end-timestamps (Unix time, UTC timezone)
ResponseTargetOptional. Specify inbox, outbox, cell or cell-range to write any response to

Return Value

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.

Example

AB
1lat50.38
2lon6.57
3start1615994572
4end1616080972
FunctionComment
=OPENWEATHER.AIRPOLLUTION.HISTORICAL("123key",JSON(A1:B4))Request historical air pollution data for specfied geographical coordinates and time-range