Skip to main content
Version: Streamsheets 3.0

SLACK.CHANNEL.LIST

Premium

Lists all channels within a Slack workspace. This functions takes an optional JSON parameter to define more advanced settings and additional options. Please refer to conversations API for more information about available and supported options (as of 2021-05-17).

Syntax

=SLACK.CHANNEL.LIST([OptionsJSON], [ResponseTarget])

Arguments

NameTypeDescription
OptionsJSON (optional)JSONA JSON which contains additional options
ResponseTarget (optional)TargetSpecify inbox, outbox, cell or cell-range to write any response to

Return

TypeDescription
Boolean,Result,ErrorRequest result if no target is specified or TRUE. In case of an error the corresponding error-code is returned.

Examples

AB
1limit10
FormulaResultComment
=SLACK.CHANNEL.LIST(,INBOX())
Requests all available channels and sends server response to inbox
=SLACK.CHANNEL.LIST(JSON(A1:B1),INBOX())
Same as before but limits channels in response