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

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