Reactions

Create, delete, and query reactions on items.

Select

The adapter processes the filters client-side within the adapter.

SELECT * FROM Reactions

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, and Name. For example:

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

Slack does not support UPDATE for reactions.

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

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

Name	Type	ReadOnly	Description
Id	String	False	The Id of the reacted item.
ChannelId	String	False	The ChanneldId where item is reacted
Type	String	True	The type of the reacted item.
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