ODBC Driver for Slack

Build 23.0.8839


Create, delete, and query all items pinned to a channel.


You must specify the ChannelId column in the WHERE clause to query the Pins table.

The 本製品 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 本製品 processes other filters client-side within the 本製品.

For example, the following query is processed server side:

SELECT * FROM Pins WHERE ChannelId = 'D71R6CSR1'


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

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


Slack does not support UPDATE for pins.


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'


Name Type ReadOnly Description
Id [KEY] String False

The Id of the pinned item.

Type [KEY] String False

The type of the pinned item.

使用できる値は次のとおりです。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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839