turbot/slack

GitHub
steampipe plugin install slacksteampipe plugin install slack

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
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
createdtimestamp with 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 with 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 with time zoneTime when the topic was last set.
workspace_domaintextThe domain name for the workspace.