Query and delete team files.
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.
Slack does not allow inserting new files.
Slack does not allow updating files.
Files can be deleted by providing the Id of the file.
DELETE FROM Files WHERE Id = 'F71R6DRR1'
The Id of the file.
The name of the file. It may nbe null for unnamed files
The title of the file.
Creation date of the file.
User ID of the member that created this file.
Username of the file creator.
A comment from the file uploader, and will only be set when the uploader left a comment at the time of upload.
The filesize in bytes. Snippets are limited to a maximum file size of 1 megabyte
The type of the file.
Mime type of the file.
Human-readable version of the type.
Number of comments made on the file.
A property that contains one of hosted, external, snippet or post.
A list of channel IDs in which the file is currently shared.
A list of private groups IDs in which the file is currently shared.
A list of instant message IDs in which the file is currently shared.
Indicates that files are stored in editable mode.
URL that points to a single page for the file containing details, comments and a download link.
If the file is available to the public, this URL points to the public file itself.
Present for posts and snippets. The page where the file can be edited
Points to a URL to the file contents.
For editable-mode files, this parameter includes headers to force a browser download.
Contains the URL of an 480x480 thumb.
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.
Filter files appearing in a specific channel, indicated by its ID.
Filter by this column to retrieve all files that contain the word in the criteria.
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.