Reactions

Create, delete, and query reactions on items.

Select

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

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	References	Description
Id	String	False		The Id of the reacted item.
ChannelId	String	False	Channels.Id	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 Team Id of the reaction.