Channels

Create, update, and query the available channels in Slack.

Select

The connector will use the Slack API to process search criteria that refer to the Id, IsArchived, IsPublic, IsGroup, IsDirectMessage, IsMultipartyDirectMessage and User columns. These columns support server-side processing for the = operator. The connector processes other filters client-side within the connector.

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' 
 SELECT * FROM Channels WHERE User = 'U03AZBU3CMT'

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	Id of the user.
IsUserDeleted	Boolean	True
Priority	String	True

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用します。データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
TeamId	String