Create, update, delete, and query the available messages in Slack.

Select

The Messages table requires ChannelId or SearchTerm in the WHERE clause. The driver also uses the Slack API to process search criteria that refer to the Id column. The ChannelId, SearchTerm, and Id columns support server-side processing for the = operator. The driver processes other search criteria client-side within the driver.

SELECT * FROM Messages WHERE ChannelId = 'D71R6CSR1'
SELECT * FROM Messages WHERE SearchTerm = 'text' 

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

Slack allows inserts only when ChannelId and Text are specified.

INSERT INTO Messages (ChannelId, Text) VALUES ('D71R6CSR1', 'This is a message')

Update

The Messages table allows updates only for the Text field. Specify ChannelId and Id.

UPDATE Messages Set Text = 'Updated message' WHERE ChannelId = 'D71R6CSR1' AND Id = '1234567890.123456' 

Delete

Messages can be deleted by providing the ChannelId and the Id of the message.

DELETE FROM Messages WHERE ChannelId = 'D71R6CSR1' AND Id = '1234567890.123456' 

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	The Id of the message.
ChannelId [KEY]	String	False	The Id of the channel the message was posted to.
UserId	String	True	The Id of the user that posted the message.
Text	String	False	Text of the message.
Type	String	True	Type of the message.
Item_type	String	True	Item type of the message.
Subtype	String	True	Subtype of the message.
Team	String	True	Team of the message.
Pinned_to	String	False	Pinned details of the message.
Pinned_info_Channel	String	True	Id of the pinned channel of the message.
Pinned_info_pinned_by	String	True	Id of the pinned by message.
Pinned_info_pinned_ts	String	True	Id of the pinned message of the message.
AttachmentsAggregate	String	True	Attachments made to the message.
Purpose	String	False	Purpose of the message.
BotId	String	True	BotId of the message.
BotLink	String	True	BotLink of the message.
Username	String	True	UserName of the message.
Reply_count	Integer	False	Count of the replied channels to the message.
Reply_users_count	Integer	False	Count of the replied users to the message.
Latest_reply	String	True	Latest message reply of the message.
Last_read	String	True	Last read message.
Reply_usersAggreagte	String	True	Replied user details of the message.
Subscribed	Boolean	True	Subscribed status of the message.
Topic	String	True	Topic of the message.
Old_name	String	False	Old Name of the message.
Name	String	False	Name of the message.
SearchTerm	String	True	Filter by this column to retrieve all messages that contain the word in the criteria.