turbot/slack

steampipe plugin install slacksteampipe plugin install slack
On This Page
Get Involved

Table: slack_conversation

The Slack Conversations API provides your app with a unified interface to work with all the channel-like things encountered in Slack: public channels, private channels, direct messages, group direct messages, and shared channels.

Examples

Conversations shared with external workspaces

select
id,
name,
is_shared
from
slack_conversation
where
is_ext_shared;
select
name,
num_members
from
slack_conversation
where
num_members is not null
order by
num_members desc
limit
5;

The #general channel (whatever it is called)

select
*
from
slack_conversation
where
is_general;

Get conversation by ID

select
*
from
slack_conversation
where
id = 'C02GC4A7Q';

All private channel and group conversations

select
name,
created,
is_channel,
is_group,
is_private
from
slack_conversation
where
is_private
and (
is_channel
or (
is_group
and not is_mpim
)
)
order by
name;

.inspect slack_conversation

Unified interface to all conversation like things including public channels, private channels, direct messages, group direct messages and shared channels.

NameTypeDescription
createdtimestamp without time zoneTime when the conversation was created.
creatortextID of the user who created the conversation.
idtextID of the conversation.
is_archivedbooleanIf true, the conversation has been archived.
is_channelbooleanIf true, the conversation is a public channel inside the workspace.
is_ext_sharedbooleanIf true, the conversation is shared with an external workspace.
is_generalbooleanIf true, this is the #general public channel (even if it's been renamed).
is_groupbooleanIf true, the conversation is a private channel.
is_imbooleanIf true, the conversation is a direct message between two individuals or a user and a bot.
is_memberbooleanIf true, the user running this query is a member of this conversation.
is_mpimbooleanIf true, this is an unnamed private conversation between multiple users.
is_org_sharedbooleanIf true, the conversation is shared between multiple workspaces within the same Enterprise Grid.
is_pending_ext_sharedbooleanIf true, the conversation hopes is awaiting approval to become is_ext_shared.
is_privatebooleanIf true, the conversation is privileged between two or more members.
is_sharedbooleanIf true, the conversation is shared across multiple workspaces. See also is_ext_shared.
nametextName of the conversation.
name_normalizedtextName of the conversation normalized into simple ASCII characters.
num_membersbigintNumber of members in the conversation. Not set if the conversation is individual messages between fixed number of users.
purposetextPurpose of the conversation / channel.
purpose_creatortextUser who created the purpose for the conversation.
purpose_last_settimestamp without time zoneTime when the purpose was last set.
topictextTopic of the conversation / channel.
topic_creatortextUser who created the topic for the conversation.
topic_last_settimestamp without time zoneTime when the topic was last set.