Skip to main content
Version: Streamsheets 2.5

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).

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)
ResponseTarget (optional)Specify inbox, outbox, cell or cell-range to write any 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

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