ODBC Driver for Slack

Build 23.0.8839


Create, delete, and query reactions on items.


The 本製品 will use the Slack API to process search criteria that refer to the Team, Users column. This column supports server-side processing for the = operator. The 本製品 processes other filters client-side within the 本製品.

SELECT * FROM Reactions WHERE Users = 'U046AV8HU3G'

SELECT * FROM Reactions WHERE Team = 'T046W75LRTK' 

SELECT * FROM Reactions WHERE Team = 'T046W75LRTK' AND Users = 'U046AV8HU3G' 


Inserts are allowed when you specify the ChannelId, Id, Name and Type. For example:

INSERT INTO Reactions (ChannelId, Id, Type, Name) VALUES ('C04HBS2PS56', '1672114112.994259', 'message', 'raised_hands')


Slack does not support UPDATE for reactions.


You can delete a pin by providing the ChannelId, Id, Name and Type.

DELETE FROM Reactions WHERE Name = 'raised_hands' AND ChannelId = 'C04HBS2PS56' AND Id = '1672114112.994259' AND  type = 'message'


Name Type ReadOnly Description
Id String False

The Id of the reacted item.

ChannelId String False

The ChanneldId where item is reacted

Type String False

The type of the reacted item.

使用できる値は次のとおりです。message, file, file comment

Name String False

The name of the reaction

Count String True

The count of reactions on that message

Users String True

The encoded user id of the user who reacted to the message.

Team String True

The name of the reaction

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