Messages
Create, update, delete, and query the available messages in Slack.
Table Specific Information
Select
The 本製品 uses the Slack API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the 本製品.
- ChannelId supports the = operator.
- SearchTerm supports the = operator.
- CreatedTime supports the <,>,>=,<=,= operator.
Note: The Messages table requires ChannelId or SearchTerm in the WHERE clause. In the case of a simple select, the Slack automatically adds the ChannelId where the current user is a member of the channel to the WHERE clause.
SELECT * FROM Messages WHERE ChannelId = 'D71R6CSR1' SELECT * FROM Messages WHERE SearchTerm = 'text' SELECT * FROM Messages WHERE CreatedTime >= '7-30-2023 00:00:00' AND CreatedTime <= '8-4-2023 00:00:00'
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. |
UserEditedDate | String | True |
The date of the edited message. |
UserEditedId | String | True |
The user id of the edited message. |
CreatedTime | Datetime | True |
The created date time of the message. |