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_sharedfrom slack_conversationwhere is_ext_shared;
Most popular conversations
select name, num_membersfrom slack_conversationwhere num_members is not nullorder by num_members desclimit 5;
The #general channel (whatever it is called)
select *from slack_conversationwhere is_general;
Get conversation by ID
select *from slack_conversationwhere id = 'C02GC4A7Q';
All private channel and group conversations
select name, created, is_channel, is_group, is_privatefrom slack_conversationwhere 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.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
created | timestamp with time zone | Time when the conversation was created. |
creator | text | ID of the user who created the conversation. |
id | text | ID of the conversation. |
is_archived | boolean | If true, the conversation has been archived. |
is_channel | boolean | If true, the conversation is a public channel inside the workspace. |
is_ext_shared | boolean | If true, the conversation is shared with an external workspace. |
is_general | boolean | If true, this is the #general public channel (even if it's been renamed). |
is_group | boolean | If true, the conversation is a private channel. |
is_im | boolean | If true, the conversation is a direct message between two individuals or a user and a bot. |
is_member | boolean | If true, the user running this query is a member of this conversation. |
is_mpim | boolean | If true, this is an unnamed private conversation between multiple users. |
is_org_shared | boolean | If true, the conversation is shared between multiple workspaces within the same Enterprise Grid. |
is_pending_ext_shared | boolean | If true, the conversation hopes is awaiting approval to become is_ext_shared. |
is_private | boolean | If true, the conversation is privileged between two or more members. |
is_shared | boolean | If true, the conversation is shared across multiple workspaces. See also is_ext_shared. |
name | text | Name of the conversation. |
name_normalized | text | Name of the conversation normalized into simple ASCII characters. |
num_members | bigint | Number of members in the conversation. Not set if the conversation is individual messages between fixed number of users. |
purpose | text | Purpose of the conversation / channel. |
purpose_creator | text | User who created the purpose for the conversation. |
purpose_last_set | timestamp with time zone | Time when the purpose was last set. |
topic | text | Topic of the conversation / channel. |
topic_creator | text | User who created the topic for the conversation. |
topic_last_set | timestamp with time zone | Time when the topic was last set. |
workspace_domain | text | The domain name for the workspace. |