Stars
Create,List or Delete a user's saved items.
Select
The adapter will use the Slack API to process search criteria that refer to the Team column. This column supports server-side processing for the = operator. The adapter processes other filters client-side within the adapter.
SELECT * FROM Stars
SELECT * FROM Stars WHERE Team='T046W75LRTK'
Insert
Inserts are allowed when you specify the ChannelId, Id and Type. For example:
INSERT INTO Stars(ChannelId, Id, Type) VALUES('C046W75NBHP', '1666336493.256699', 'message'))
Update
Slack does not support the update of reactions.
Delete
You can delete a pin by providing the ChannelId, Id and Type.
DELETE FROM Stars WHERE ChannelId='C046W75NBHP' AND Id='1666336493.25/6699' AND Type='message'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The Id of the starred item. |
| ChannelId | String | False |
The ChannelId where the item is starred |
| Type [KEY] | String | False |
The type of the starred item. The allowed values are message, file, file comment. |
| Team | String | True |
The encoded team id of the user who saved the message. |
| User | String | True |
The encoded user id of the user who saved the message. |
| CreatedAt | Datetime | True |
The timestamp of item saved |