Reactions
Create, delete, and query reactions on items.
Select
The adapter 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 adapter processes other 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'
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 the update of 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 |