JDBC Driver for Slack

Build 22.0.8462

Stars

Create,List or Delete a user's saved items.

Select

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

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462