Skip to main content
Version: Streamsheets 2.5

SLACK.CHANNEL.LIST

star This is a Streamsheets Enterprise feature.

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 https://api.slack.com/methods/conversations.list for more information about available and supported options (as of 2021-05-17).

Syntax

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

Arguments

NameDescription
TokenA token which is registered to a workspace and has required access rights
ResponseTarget (optional)Specify inbox, outbox, cell or cell-range to write any response to
OptionsJSON (optional)A JSON which contains additional options

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
1limit10
FormulaResultComment
=SLACK.CHANNEL.LIST("123key",INBOX())
Requests all available channels and sends server response to inbox
=SLACK.CHANNEL.LIST("123key",INBOX(), JSON(A1:B1))
Same as before but limits channels in response