JDBC Driver for Slack

Build 22.0.8462

Files

Query and delete team files.

Select

The driver will use the Slack API to filter by search criteria that refer to the Id, Created, UserId, Types, SpecificChannel, or SearchTerm columns. All columns support server-side processing for the = operator, and the Created column also supports server-side processing for the >, >=, <, <= operators.

The driver processes other search criteria client-side within the driver.

For example, the following queries are processed server side:

SELECT * FROM Files WHERE Created > '2017-01-01' AND UserId = 'U2345NDS' AND SpecificChannel = 'D71R6CSR1'

You can also filter files by querying the files' contents: Set the SearchTerm pseudocolumn in the criteria. All files containing the queried word will be retrieved. For example:

SELECT * FROM Files WHERE SearchTerm = 'text'
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

Slack does not allow inserting new files.

Update

Slack does not allow updating files.

Delete

Files can be deleted by providing the Id of the file.

DELETE FROM Files WHERE Id = 'F71R6DRR1'

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Id of the file.

Name String True

The name of the file. It may nbe null for unnamed files

Title String True

The title of the file.

Created Datetime True

Creation date of the file.

UserId String True

User ID of the member that created this file.

Username String True

Username of the file creator.

InitialComment String True

A comment from the file uploader, and will only be set when the uploader left a comment at the time of upload.

Size Integer True

The filesize in bytes. Snippets are limited to a maximum file size of 1 megabyte

Filetype String True

The type of the file.

Mimetype String True

Mime type of the file.

PrettyType String True

Human-readable version of the type.

CommentsCount Integer True

Number of comments made on the file.

Mode String True

A property that contains one of hosted, external, snippet or post.

PublicChannelIds String True

A list of channel IDs in which the file is currently shared.

GroupIds String True

A list of private groups IDs in which the file is currently shared.

DirectMessageIds String True

A list of instant message IDs in which the file is currently shared.

Editable Boolean True

Indicates that files are stored in editable mode.

Permalink String True

URL that points to a single page for the file containing details, comments and a download link.

PermalinkPublic String True

If the file is available to the public, this URL points to the public file itself.

EditLink String True

Present for posts and snippets. The page where the file can be edited

UrlPrivate String True

Points to a URL to the file contents.

UrlPrivateDownload String True

For editable-mode files, this parameter includes headers to force a browser download.

Thumb480 String True

Contains the URL of an 480x480 thumb.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
SpecificChannel String

Filter files appearing in a specific channel, indicated by its ID.

SearchTerm String

Filter by this column to retrieve all files that contain the word in the criteria.

Types String

Filter files by type. Allowed values are all,spaces,snippets,images,gdocs,zips. Default value is all.

The allowed values are all, spaces, snippets, images, gdocs, zips.

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