ADO.NET Provider for Slack

Build 24.0.9062

MessageReplies

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

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 本製品.

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 Description
Id [KEY] String True

Unique identifier for the messages.

ChannelId [KEY] String False

Conversation ID to fetch thread from.

UserId String True

User Id of the user who posted the reply.

Text String False

Reply message content.

ParentMessageId [KEY] String False

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062