Pins
Create, delete, and query all items pinned to a channel.
Select
You must specify the ChannelId column in the WHERE clause to query the Pins table.
The connector will use the Slack API to process search criteria that refer to the ChannelId column. This column supports server-side processing for the = operator. The connector processes other filters client-side within the connector.
For example, the following query is processed server side:
SELECT * FROM Pins WHERE ChannelId = 'D71R6CSR1'
Insert
INSERTS are allowed when you specify the ChannelId and Id. For example:
INSERT INTO Pins (ChannelId, Id) VALUES ('D71R6CSR1', 'F71R6DRR1')
Update
Slack does not support UPDATE for pins.
Delete
You can delete a pin by providing the ChannelId and Id.
DELETE FROM Pins WHERE ChannelId = 'D71R6CSR1' AND Id = '1505287261.000226'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The Id of the pinned item. |
| Type [KEY] | String | True |
The type of the pinned item. |
| Created | Datetime | True |
A unique datetime representing when the item was pinned. |
| ChannelId [KEY] | String | False |
Channel Id to get pinned items for. |
| PinnedToChannelIds | String | True |
Comma separated list of channel ids the item is pinned to. |
| CreatedBy | String | True |
The encoded user id of the user who pinned the item. |