Channels
Create, update, and query the available channels in Slack.
Select
The driver will use the Slack API to process search criteria that refer to the Id, IsArchived, IsPublic, IsGroup, IsDirectMessage, and IsMultipartyDirectMessage columns. These columns support server-side processing for the = operator. The driver processes other filters client-side within the driver.
For example, the following queries are processed server side by the Slack APIs:
SELECT * FROM Channels WHERE IsPublic = false AND IsGroup = false AND IsArchived = true SELECT * FROM Channels WHERE Id = 'D71R6CSR1'You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.
Insert
The Name column is the minimum requirement for an insert. Name and IsPublic are the only columns that can be set on an insert.
INSERT INTO Channels (Name, IsPublic) VALUES ('initialname', true)
Update
The Channels table allows updates for columns Name, Purpose, and Topic when Id is specified.
UPDATE Channels SET Topic = 'A Topic Text', Purpose = 'A Purpose Text', Name = 'updatedname' WHERE Id = 'D71R6CSR1'
Delete
Slack does not allow Channels to be deleted.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The Id of the channel. |
| Name | String | False |
The name of the channel. |
| Topic | String | False |
Information about the channel topic. |
| TopicCreator | String | True |
Creator of the channel topic. |
| Purpose | String | False |
Information about the channel purpose. |
| TotalMembers | Integer | True |
Number of members in the channel. |
| Created | Datetime | True |
Channel creation datetime. |
| Creator | String | True |
User ID of the member that created this channel. |
| LastRead | Datetime | True |
The datetime for the last message the calling user has read in this channel. |
| IsMember | Boolean | True |
Indicates the user or bot user or Slack app associated with the token making the API call is itself a member of the conversation. |
| IsArchived | Boolean | True |
Indicates a conversation is archived. Frozen in time |
| IsPublic | Boolean | False |
Indicates whether a conversation is a public channel. Everything said in a public channel can be read by anyone else belonging to a workspace. |
| IsGroup | Boolean | True |
Indicates whether the channel is a private channel between a group of members. |
| IsDirectMessage | Boolean | True |
Means the conversation is a direct message between two distinguished individuals or a user and a bot. |
| IsMultipartyDirectMessage | Boolean | True |
Represents an unnamed private conversation between multiple users. |
| IsGeneral | Boolean | True |
Means the channel is the workspace's 'general' discussion channel. |
| Unlinked | Integer | True |
Number of times a link to the channel has been removed. |
| NameNormalized | String | True |
Normalized name of the channel. |
| IsShared | Boolean | True |
Means the conversation is in some way shared between multiple workspaces. |
| IsExtShared | Boolean | True |
Represents this conversation as being part of a Shared Channel with a remote organization. |
| IsOrgShared | Boolean | True |
Explains whether this shared channel is shared between Enterprise Grid workspaces within the same organization. |
| IsPendingExtShared | Boolean | True |
It means the conversation is ready to become an IsExtShared channel but isn't quite ready yet and needs some kind of approval or sign off. |
| PreviousNames | String | True |
A list of previous names this channel has had. |
| Locale | String | True |
Locale of the channel. |
| User | String | True | |
| IsUserDeleted | Boolean | True | |
| Priority | String | True |