Reactions
Create, delete, and query reactions on items.
Select
The driver 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 driver processes other filters client-side within the driver.
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, Name and Type. For example:
INSERT INTO Reactions (ChannelId, Id, Type, Name) VALUES ('C04HBS2PS56', '1672114112.994259', 'message', 'raised_hands')
Update
Slack does not support UPDATE for reactions.
Delete
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'
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 | False |
The type of the reacted item. The allowed values are 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 |