Skip to main content
Version: Streamsheets 2.4

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

caution

This function is currently under review.

Syntax

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

Arguments

NameDescription
TokenA token which is registered to a workspace and has required access rights
ResponseTargetOptional. Specify inbox, outbox, cell or cell-range to write any response to
OptionsJSONOptional. A JSON which contains additional options

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
1limit10
FunctionComment
=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