MessageReplies

Create, update, delete, and query threads of messages posted to a conversation.

Table Specific Information

Select

The connector 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 connector.

The MessageReplies table requires ChannelId and ParentMessageId columns in the WHERE clause; otherwise, the driver will automatically add these columns.

ChannelId supports the = operator.
ParentMessageId supports the = operator.
CreatedTime supports the <,>,>=,<=,= operator.
ParentCreatedTime supports the <,>,>=,<=,= operator.

For example, the following query is processed server side:

SELECT * FROM MessageReplies WHERE ChannelId = 'D71R6CSR1' AND ParentMessageId = '1234567890.123456'

Insert

Slack allows inserts only when ChannelId, Text, and ParentMessageId are specified.

INSERT INTO MessageReplies (ChannelId, Text, ParentMessageId) VALUES ('D71R6CSR1', 'This is a message', '1234567890.123456')

Update

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

UPDATE MessageReplies SET Text = 'Updated message' WHERE ChannelId = 'D71R6CSR1' AND Id = '1234567890.123456'

Delete

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

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

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique identifier for the messages.
ChannelId [KEY]	String	False	Channels.Id	Conversation ID to fetch thread from.
UserId	String	True	Users.Id	User Id of the user who posted the reply.
Text	String	False		Reply message content.
ParentMessageId [KEY]	String	False	Messages.Id	Unique identifier of a thread's parent message.
ReplyCount	Integer	True		The replies number for thread's parent message.
Subscribed	Boolean	True		Indicates if the user is subscribed to this channel.
LastRead	Datetime	True		The datetime for the last message the calling user has read in this channel.
UnreadCount	Integer	True		The number of members that have not read the parent message.
CreatedTime	Datetime	True		The created date time of the message reply.
ParentCreatedTime	Datetime	True		The parent message created date time.