Reactions
Create, delete, and query reactions on items.
Select
The 本製品 processes the filters client-side within the 本製品.
SELECT * FROM Reactions
SELECT * FROM Reactions WHERE Users = 'U046AV8HU3G'
SELECT * FROM Reactions WHERE Team = 'T046W75LRTK'
SELECT * FROM Reactions WHERE Team = 'T046W75LRTK' AND Users = 'U046AV8HU3G'
Insert
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')
Update
Slack does not support UPDATE for reactions.
Delete
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'
Columns
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 |