Slack Tables

SlackAccessLogs

Each access log entry represents a user accessing Slack from a specific user, IP address, and user agent combination.

Name	Type	Description
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
Count	integer	The total number of times an access log entry has been recorded for a given combination.
Country	string	The estimated region within the country where the access attempt was made, based on the IP address.
DateFirst	datetime	The Unix timestamp marking the first recorded access for a specific user, IP address, and user agent combination
DateLast	datetime	The Unix timestamp indicating the most recent access for that same combination.
ID	integer	Unique identifier for the access log.
IP	string	The IP address from which the user accessed Slack.
ISP	string	The estimated internet service provider associated with the recorded IP address.
Region	string	The estimated country from which the access originated, based on the IP address.
UserAgent	string	The user agent string reported by the browser or client application at the time of access.
UserID	string	The unique identifier of the user associated with the access log entry.
UserName	string	The username of the individual who accessed Slack.

SlackFiles

Stores metadata for files hosted or shared in Slack workspaces

Name	Type	Description
ConfigID	integer	Identifier of the Compyl integeregration configuration that sourced the data.
FileID	string	Unique identifier of the file assigned by Slack (e.g., `F123ABC456`).
Created	datetime	UTC timestamp when the file was first uploaded to Slack.
Timestamp	datetime	Same as Created; retained for compatibility with Slack's timestamp field.
Name	string	Original filename including extension.
Title	string	User‑friendly title shown in Slack UI.
MimeType	string	Standard MIME type of the file content (e.g., `image/png`, `application/pdf`).
FileType	string	Slack's short file type identifier (e.g., `png`, `docx`).
PrettyType	string	Human‑readable version of FileType (e.g., `PNG`).
UserID	string	User ID of the individual who uploaded the file.
Editable	bit	1 if the file supports in‑place editing via Slack or the connected service.
Size	integer	File size in bytes.
Mode	string	Hosting mode for the file (`hosted`, `snippet`, `post`, `external`, etc.).
IsExternal	bit	Indicates whether the file is stored outside Slack.
ExternalType	string	Name of the external service when `IsExternal = 1` (e.g., `gdrive`, `dropbox`).
IsPublic	bit	True if the file is shared in a public channel.
PublicUrlShared	bit	True if a public URL has been generated and shared.
DisplayAsBot	bit	True when the message displaying the file is posted as a bot.
Username	string	Username
UrlPrivate	string	Authenticated URL to access the file within Slack.
UrlPrivateDownload	string	Direct authenticated download link.
ThumbUrlsJson	string	`JSON` object containing thumbnail URLs keyed by resolution.
OriginalWidth	integer	Width of the original image/video, in pixels (if applicable).
OriginalHeight	integer	Height of the original image/video, in pixels (if applicable).
CommentsCount	integer	Number of comments on the file at the time of sync.
BatchDate	datetime	Timestamp when the record was synchronized integero Compyl.

SlackGroups

Each group represents a user group within a team.

Name	Type	Description
AutoType	string	Can be admins for a Workspace Admins group, owners for a Workspace Owners group or null for a custom group.
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
CreatedBy	string	User ID of the member who created the user group.
CreatedDate	datetime	When the user group was created.
DeletedBy	string	User ID of the member who deleted the user group.
DeletedDate	datetime	Non-zero value for disabled groups.
Description	string	Explains the purpose of the group (optional).
GroupID	string	The ID of the usergroup.
Handle	string	Indicates the value used to notify group members via a mention without a leading @ sign.
isExternal	boolean	Indicates if the user group is external.
isUserGroup	boolean	Indicates if the object is a user group.
Name	string	Indicates the friendly name of the group.
TeamID	string	The ID of the team.
UpdatedBy	string	User ID of the member who updated the user group.
UpdatedDate	datetime	User ID of the member who deleted the user group.
UserCount	integer	Indicates the total number of users in a group.

SlackRemoteFiles

Stores metadata for remote file references (files hosted on external services)

Name	Type	Description
ConfigID	integer	Identifier of the Compyl integration configuration that sourced the data.
FileID	string	Unique identifier of the file assigned by Slack (e.g., `F123ABC456`).
Created	datetime	UTC timestamp when the file was first uploaded to Slack.
Timestamp	datetime	Same as Created; retained for compatibility with Slack's timestamp field.
Name	string	Original filename including extension.
Title	string	User‑friendly title shown in Slack UI.
MimeType	string	Standard MIME type of the file content (e.g., `image/png`, `application/pdf`).
FileType	string	Slack's short file type identifier (e.g., `png`, `docx`).
PrettyType	string	Human‑readable version of FileType (e.g., `PNG`).
UserID	string	User ID of the individual who uploaded the file.
Editable	bit	1 if the file supports in‑place editing via Slack or the connected service.
Size	bigint	File size in bytes.
Mode	string	Hosting mode for the file (`hosted`, `snippet`, `post`, `external`, etc.).
IsExternal	bit	Indicates whether the file is stored outside Slack.
ExternalType	string	Name of the external service when `IsExternal = 1` (e.g., `gdrive`, `dropbox`).
IsPublic	bit	True if the file is shared in a public channel.
PublicUrlShared	bit	True if a public URL has been generated and shared.
DisplayAsBot	bit	True when the message displaying the file is posted as a bot.
Username	string	Username
UrlPrivate	string	Authenticated URL to access the file within Slack.
UrlPrivateDownload	string	Direct authenticated download link.
ThumbUrlsJson	string	`JSON` object containing thumbnail URLs keyed by resolution.
OriginalWidth	integer	Width of the original image/video, in pixels (if applicable).
OriginalHeight	integer	Height of the original image/video, in pixels (if applicable).
CommentsCount	integer	Number of comments on the file at the time of sync.
BatchDate	datetime	Timestamp when the record was synchronized into Compyl.

SlackUsers

Each user represents users in a workspace. This includes both invited users and deleted/deactivated users.

Name	Type	Description
APIAppID	string	refers to the unique identifier of the Slack app that is currently interacting with a user
BatchDate	datetime	The date and time data was synced to our database.
BotID	string	Indicates whether the user is actually a bot user.
ConfigID	integer	The ID of the configuration within Compyl.
Deleted	boolean	This user has been deactivated when the value of this field is true. Otherwise the value is false, or the field may not appear at all.
DisplayName	string	The display name the user has chosen to identify themselves by in their workspace profile.
DisplayNameNormalized	string	The display_name field, but with any non-Latin characters filtered out.
Email	string	A valid email address.
FirstName	string	The user's first name.
Has2fa	boolean	Describes whether two-factor authentication is enabled for this user.
IsAdmin	boolean	Indicates whether the user is an Admin of the current workspace.
IsAppUser	boolean	Indicates whether the user is an authorized user of the calling app.
IsBot	boolean	Indicates whether the user is actually a bot user.
IsInvitedUser	boolean	Only present (and always true) when a user has been invited but has not yet signed in.
IsOwner	boolean	Indicates whether the user is an Owner of the current workspace.
IsPrimaryOwner	boolean	Indicates whether the user is the Primary Owner of the current workspace.
IsRestricted	boolean	Indicates whether or not the user is a guest user.
IsUltraRestricted	boolean	Indicates whether or not the user is a single-channel guest.
JobTitle	string	The user's title.
LastName	string	The user's last name.
Locale	string	Contains a IETF language code that represents this user's chosen display language for Slack clients.
Phone	string	The user's phone number, in any format.
RealName	string	The user's first and last name.
RealNameNormalized	string	The real_name field, but with any non-Latin characters filtered out.
Skype	string	Always an empty string. Skype is no longer with us.
TeamID	string	The ID of the team the user is on.
Timezone	string	Describes the commonly used name of the timezone.
Updated	datetime	A Unix timestamp indicating when the user object was last updated.
UserID	string	Identifier for this workspace user.
UserName	string	It indicated the preferred username for a user. However, please don't use, this has been phased out.

SlackAccessLogs

SlackFiles

SlackGroups

SlackRemoteFiles

SlackUsers

Learn more...