ODBC Driver for Slack

Build 23.0.8839


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


The MessageReplies table requires the ChannelId And ParentMessageId columns in the WHERE clause. Search criteria that refer to other columns are processed client-side within the 本製品.

For example, the following query is processed server side:

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


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')


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' 


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

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


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.

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