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 driver 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 driver processes other filters client-side within the driver.

For example, the following query is processed server side:

SELECT * FROM Pins WHERE ChannelId = 'D71R6CSR1'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Insert

INSERTS are allowed when you specify the ChannelId, Id, and Type. For example:

INSERT INTO Pins (ChannelId, Id, Type) VALUES ('D71R6CSR1', 'F71R6DRR1', 'file')

Update

Slack does not support the update of pins.

Delete

You can delete a pin by providing the ChannelId, Id, and Type.

DELETE FROM Pins WHERE ChannelId = 'D71R6CSR1' AND Id = '1505287261.000226' AND Type = 'message'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The Id of the pinned item.
Type [KEY]	String	False	The type of the pinned item. The allowed values are message, file, file comment.
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.