Slack

Slack is a cloud-based team communication platform.

Slack integration replicates data from a single Slack workspace using the Slack Web API. To replicate data from multiple workspaces, create an additional Slack integration for each workspace.

See the Schema section for a list of objects available for replication.

Immagine di alto livello di questo connettore, inclusi collegamenti utili e funzionalità supportate.

Funzionalità/Capacità	Dettagli del supporto
Progetti Qlik Talend Data Integration supportati	Solo i progetti di replica. I progetti delle pipeline di dati non sono supportati.
Metodi di aggiornamento della destinazione	Attività di replica: Applica modifiche Archivia modifiche Trasferimento dei dati nelle attività di un data lake: Change Data Capture (CDC)
Gestione dei metadati	La generazione manuale dei metadati non è richiesta.
Evoluzione dello schema	È supportata solo l'operazione Cambia tipo di dati colonne.
Replica delle colonne LOB (NCLOB, CLOB e BLOB)	Operazione non supportata.
CDC pianificato	Operazione richiesta. In questo modo la destinazione viene aggiornata con le modifiche apportate alla sorgente. Per le attività di replica, vedere Attività di pianificazione Per le attività di trasferimento su data lake, vedere Pianificazione delle attività CDC per i processi di trasferimento su data lake
Notifiche	Operazione parzialmente supportata Impostare notifiche quando vengono apportate modifiche al funzionamento
Monitoraggio	Solo attività CDC, in quanto il caricamento completo non è rilevante per questo connettore. Monitoraggio di un'attività dati individuale
Annullamento automatico della nidificazione dei payload nelle colonne JSON	Operazione non supportata. La nidificazione per i payload della colonna JSON nei set di dati di origine non viene annullata automaticamente nella destinazione.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Assicurarsi che l'account utilizzata disponga di accesso di lettura per le tabelle che si desidera recuperare.

Qlik Talend Cloud supports data replication from one Slack workspace per connection. To replicate data from multiple workspaces, set up a separate Slack connection for each workspace in Qlik Talend Cloud, using a unique OAuth token for every connection.

To retrieve your token:

Navigate to the Slack App site.
Click Create an App.
Enter a name for the app and select the workspace you want to replicate data from.
Click Create App.
Once your app is created, select it and navigate to Features > OAuth & Permissions.
Scroll to the Scopes section.
In the Bot Token Scopes section, click Add an OAuth Scope.
In the field that appears, search for the following scopes:
- channels:history
- channels:join
- channels:read
- files:read
- groups:read
- links:read
- reactions:read
- remote_files:read
- remote_files:write
- team:read
- useergroups:read
- users.profile:read
- users:read
- users:read.email
After the required scopes are added to the app, you need to install it to your Slack workspace. If you do not have the required permissions to install apps, you may need Workspace Owner approval. See Slack's documentation for app installation requirements.
Scroll up to the OAuth Tokens & Redirect URLs section of the OAuth & Permissions page.
In this section, click Install App to Workspace.
Complete the steps that follow to install the app or submit a request to your Workspace Owner for approval.
Result: Once the app is installed in your workspace, a Tokens for Your Workspace section containing a Bot User OAuth Access Token field is displayed.
Copy and paste your token into a secured file.

Creating the connection

Per ulteriori informazioni, vedere Connessione alle applicazioni SaaS.

Inserire le proprietà di connessione richieste.
Fornire un nome per la connessione in Nome connessione.
Selezionare Apri metadati di connessione per definire i metadati della connessione al momento della creazione.
Fare clic su Crea.

Connection settings
Setting	Description
Data gateway	Selezionare un Gateway Data Movement se richiesto dal proprio caso di utilizzo. Nota informatica Questo campo non è disponibile con la sottoscrizione a Avvio Qlik Talend Cloud, poiché non supporta il Gateway Data Movement. Se si dispone di un altro livello di sottoscrizione e non si desidera utilizzare il Gateway Data Movement, selezionare Nessuno. Per informazioni sui vantaggi del Gateway Data Movement e quando è richiesto, vedere Qlik Data Gateway - Movimento dati.
Start Date	Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target.
Token	Token.
Join Public Channels	Select the check box to replicate data for all public channels in the workspace you are connecting.
Include Private Channels	Select the check box to include data from private channels.
Exclude Archived Channels	Select the check box to exclude data from archived channels.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

channel_members

The channel_members table contain info about members of channels in your Slack workspace. Channels include conversations, channels, and direct messages in your Slack workspace.

Replication Method

Full Table

Primary Keys

channel_id

user_id

Useful links

Slack documentation

Slack API method

Join channel_members with	on
channels	channel_members.channel_id = channels.id channel_members.user_id = channels.creator channel_members.user_id = channels.members
files	channel_members.channel_id = files.channels channel_members.channel_id = files.pinned_to channel_members.user_id = files.user
messages	channel_members.channel_id = messages.channel_id channel_members.channel_id = messages.pinned_to channel_members.user_id = messages.reply_users channel_members.user_id = messages.reactions.users channel_members.user_id = messages.user
remote_files	channel_members.channel_id = remote_files.channels channel_members.channel_id = remote_files.pinned_to channel_members.user_id = remote_files.user
threads	channel_members.channel_id = threads.channel_id channel_members.user_id = threads.user channel_members.user_id = threads.reply_users
user_groups	channel_members.user_id = user_groups.members channel_members.user_id = user_groups.purpose.creator channel_members.user_id = user_groups.topic.creator
users	channel_members.user_id = users.id

channel_id

STRING

user_id

STRING

channels

The channels table contains info about the channels in your Slack workspace. This includes conversations, channels, and direct messages.

Some types of channels - for example, private or archived channels - will be replicated only if the appropriate settings are configured in the integration’s settings. Refer to the Slack setup steps for more info.

Replication Method

Full Table

Primary Key

Useful links

Slack documentation

Slack API method

Join channels with	on
channel_members	channels.id = channel_members.channel_id channels.creator = channel_members.user_id channels.members = channel_members.user_id
files	channels.id = files.channels channels.id = files.pinned_to channels.pending_connected_team_ids = files.source_team channels.pending_connected_team_ids = files.user_team channels.creator = files.user channels.members = files.user
messages	channels.id = messages.channel_id channels.id = messages.pinned_to channels.pending_connected_team_ids = messages.bot_profile.team_id channels.pending_connected_team_ids = messages.team channels.pending_connected_team_ids = messages.source_team channels.pending_connected_team_ids = messages.user_team channels.creator = messages.reply_users channels.members = messages.reply_users channels.creator = messages.reactions.users channels.members = messages.reactions.users channels.creator = messages.user channels.members = messages.user
remote_files	channels.id = remote_files.channels channels.id = remote_files.pinned_to channels.pending_connected_team_ids = remote_files.source_team channels.pending_connected_team_ids = remote_files.user_team channels.creator = remote_files.user channels.members = remote_files.user
threads	channels.id = threads.channel_id channels.pending_connected_team_ids = threads.team channels.creator = threads.user channels.members = threads.user channels.creator = threads.reply_users channels.members = threads.reply_users
teams	channels.pending_connected_team_ids = teams.id
users	channels.pending_connected_team_ids = users.team_id channels.creator = users.id channels.members = users.id
user_groups	channels.creator = user_groups.members channels.members = user_groups.members channels.creator = user_groups.purpose.creator channels.members = user_groups.purpose.creator channels.creator = user_groups.topic.creator channels.members = user_groups.topic.creator

channel_id

STRING

created

DATE-TIME

creator

STRING

is_archived

BOOLEAN

is_channel

BOOLEAN

is_ext_shared

BOOLEAN

is_general

BOOLEAN

is_group

BOOLEAN

is_im

BOOLEAN

is_member

BOOLEAN

is_mpim

BOOLEAN

is_org_shared

BOOLEAN

is_pending_ext_shared

BOOLEAN

is_private

BOOLEAN

is_shared

BOOLEAN

members

ARRAY

This is a nested data structure.

name

STRING

name_normalized

STRING

num_members

INTEGER

parent_conversation

STRING

pending_connected_team_ids

ARRAY

This is a nested data structure.

pending_shared

ARRAY

This is a nested data structure.

previous_names

ARRAY

This is a nested data structure.

purpose

OBJECT

This is a nested data structure:

creator: STRING
last_set: DATE-TIME
value: STRING

shared_team_ids

ARRAY

This is a nested data structure.

topic

OBJECT

This is a nested data structure:

creator: STRING
last_set: DATE-TIME
value: STRING

unlinked

DATE-TIME

files

The files table contains info about Slack team files.

Replication Method	CDC
Primary Key	id
Replication Key	updated
Useful links	Slack documentation Slack API method

Join files with	on
channels	files.channels = channels.id files.pinned_to = channels.id files.source_team = channels.pending_connected_team_ids files.user_team = channels.pending_connected_team_ids files.user = channels.creator files.user = channels.members
channel_members	files.channels = channel_members.channel_id files.pinned_to = channel_members.channel_id files.user = channel_members.user_id
messages	files.channels = messages.channel_id files.pinned_to = messages.channel_id files.channels = messages.pinned_to files.pinned_to = messages.pinned_to files.id = messages.file_ids files.source_team = messages.bot_profile.team_id files.user_team = messages.bot_profile.team_id files.source_team = messages.team files.user_team = messages.team files.source_team = messages.source_team files.user_team = messages.source_team files.source_team = messages.user_team files.user_team = messages.user_team files.user = messages.reply_users files.user = messages.reactions.users files.user = messages.user
remote_files	files.channels = remote_files.channels files.pinned_to = remote_files.channels files.channels = remote_files.pinned_to files.pinned_to = remote_files.pinned_to files.groups = remote_files.groups files.source_team = remote_files.source_team files.user_team = remote_files.source_team files.source_team = remote_files.user_team files.user_team = remote_files.user_team files.user = remote_files.user
threads	files.channels = threads.channel_id files.pinned_to = threads.channel_id files.source_team = threads.team files.user_team = threads.team files.user = threads.user files.user = threads.reply_users
user_groups	files.groups = user_groups.id files.groups = user_groups.parent_group files.user = user_groups.members files.user = user_groups.purpose.creator files.user = user_groups.topic.creator
teams	files.source_team = teams.id files.user_team = teams.id
users	files.source_team = users.team_id files.user_team = users.team_id files.user = users.id

channels

ARRAY

This is a nested data structure.

comments_count

INTEGER

created

DATE-TIME

date_delete

DATE-TIME

display_as_bot

BOOLEAN

editable

BOOLEAN

editor

STRING

external_id

STRING

external_type

STRING

external_url

STRING

filetype

STRING

groups

ARRAY

This is a nested data structure.

has_rich_preview

BOOLEAN

STRING

image_exif_rotation

INTEGER

ims

ARRAY

This is a nested data structure.

is_external

BOOLEAN

is_public

BOOLEAN

is_starred

BOOLEAN

is_tombstoned

BOOLEAN

last_editor

STRING

mimetype

STRING

mode

STRING

name

STRING

non_owner_editable

BOOLEAN

num_stars

INTEGER

original_h

INTEGER

original_w

INTEGER

permalink

STRING

permalink_public

STRING

pinned_info

OBJECT

This is a nested data structure.

pinned_to

ARRAY

This is a nested data structure.

pretty_type

STRING

preview

STRING

public_url_shared

BOOLEAN

size

INTEGER

source_team

STRING

state

STRING

thumb_1024

STRING

thumb_1024_h

INTEGER

thumb_1024_w

INTEGER

thumb_160

STRING

thumb_360

STRING

thumb_360_h

INTEGER

thumb_360_w

INTEGER

thumb_480

STRING

thumb_480_h

INTEGER

thumb_480_w

INTEGER

thumb_64

STRING

thumb_720

STRING

thumb_720_h

INTEGER

thumb_720_w

INTEGER

thumb_80

STRING

thumb_800

STRING

thumb_800_h

INTEGER

thumb_800_w

INTEGER

thumb_960

STRING

thumb_960_h

INTEGER

thumb_960_w

INTEGER

thumb_tiny

STRING

timestamp

DATE-TIME

title

STRING

updated

DATE-TIME

url_private

STRING

url_private_download

STRING

user

STRING

user_team

STRING

username

STRING

messages

The messages table contains the history of messages and events in conversations in your Slack workspace.

Replication Method	CDC
Primary Keys	channel_id ts
Replication Key	ts
Useful links	Slack documentation Slack API method

Join messages with	on
channels	messages.channel_id = channels.id messages.pinned_to = channels.id messages.bot_profile.team_id = channels.pending_connected_team_ids messages.team = channels.pending_connected_team_ids messages.source_team = channels.pending_connected_team_ids messages.user_team = channels.pending_connected_team_ids messages.reply_users = channels.creator messages.reactions.users = channels.creator messages.user = channels.creator messages.reply_users = channels.members messages.reactions.users = channels.members messages.user = channels.members
channel_members	messages.channel_id = channel_members.channel_id messages.pinned_to = channel_members.channel_id messages.reply_users = channel_members.user_id messages.reactions.users = channel_members.user_id messages.user = channel_members.user_id
files	messages.channel_id = files.channels messages.pinned_to = files.channels messages.channel_id = files.pinned_to messages.pinned_to = files.pinned_to messages.file_ids = files.id messages.bot_profile.team_id = files.source_team messages.team = files.source_team messages.source_team = files.source_team messages.user_team = files.source_team messages.bot_profile.team_id = files.user_team messages.team = files.user_team messages.source_team = files.user_team messages.user_team = files.user_team messages.reply_users = files.user messages.reactions.users = files.user messages.user = files.user
remote_files	messages.channel_id = remote_files.channels messages.pinned_to = remote_files.channels messages.channel_id = remote_files.pinned_to messages.pinned_to = remote_files.pinned_to messages.bot_profile.team_id = remote_files.source_team messages.team = remote_files.source_team messages.source_team = remote_files.source_team messages.user_team = remote_files.source_team messages.bot_profile.team_id = remote_files.user_team messages.team = remote_files.user_team messages.source_team = remote_files.user_team messages.user_team = remote_files.user_team messages.reply_users = remote_files.user messages.reactions.users = remote_files.user messages.user = remote_files.user
threads	messages.channel_id = threads.channel_id messages.pinned_to = threads.channel_id messages.bot_profile.team_id = threads.team messages.team = threads.team messages.source_team = threads.team messages.user_team = threads.team messages.reply_users = threads.user messages.reactions.users = threads.user messages.user = threads.user messages.reply_users = threads.reply_users messages.reactions.users = threads.reply_users messages.user = threads.reply_users
teams	messages.bot_profile.team_id = teams.id messages.team = teams.id messages.source_team = teams.id messages.user_team = teams.id
users	messages.bot_profile.team_id = users.team_id messages.team = users.team_id messages.source_team = users.team_id messages.user_team = users.team_id messages.reply_users = users.id messages.reactions.users = users.id messages.user = users.id
user_groups	messages.reply_users = user_groups.members messages.reactions.users = user_groups.members messages.user = user_groups.members messages.reply_users = user_groups.purpose.creator messages.reactions.users = user_groups.purpose.creator messages.user = user_groups.purpose.creator messages.reply_users = user_groups.topic.creator messages.reactions.users = user_groups.topic.creator messages.user = user_groups.topic.creator

blocks

ARRAY

This is a nested data structure:

type: STRING

bot_id

STRING

bot_profile

OBJECT

This is a nested data structure:

app_id: STRING
deleted: BOOLEAN
id: STRING
name: STRING
team_id: STRING
updated: DATE-TIME

channel_id

STRING

client_msg_id

STRING

display_as_bot

BOOLEAN

file_id

STRING

file_ids

ARRAY

This is a nested data structure.

icons

OBJECT

This is a nested data structure:

emoji: STRING

inviter

STRING

is_delayed_message

BOOLEAN

is_intro

BOOLEAN

is_starred

BOOLEAN

last_read

DATE-TIME

latest_reply

STRING

name

STRING

old_name

STRING

parent_user_id

STRING

permalink

STRING

pinned_to

ARRAY

This is a nested data structure.

purpose

STRING

reactions

ARRAY

This is a nested data structure:

count: INTEGER
name: STRING
users: ARRAY, which is also a nested data structure.

reply_count

INTEGER

reply_users

ARRAY

This is a nested data structure.

reply_users_count

INTEGER

source_team

STRING

subscribed

BOOLEAN

subtype

STRING

team

STRING

text

STRING

thread_ts

STRING

topic

STRING

DATE-TIME

type

STRING

unread_count

INTEGER

upload

BOOLEAN

user

STRING

user_team

STRING

username

STRING

remote_files

The remote_files table contains info about remote files added to Slack.

Replication Method	CDC
Primary Key	id
Replication Key	updated
Useful links	Slack API method

Join remote_files with	on
channels	remote_files.channels = channels.id remote_files.pinned_to = channels.id remote_files.source_team = channels.pending_connected_team_ids remote_files.user_team = channels.pending_connected_team_ids remote_files.user = channels.creator remote_files.user = channels.members
channel_members	remote_files.channels = channel_members.channel_id remote_files.pinned_to = channel_members.channel_id remote_files.user = channel_members.user_id
files	remote_files.channels = files.channels remote_files.pinned_to = files.channels remote_files.channels = files.pinned_to remote_files.pinned_to = files.pinned_to remote_files.groups = files.groups remote_files.source_team = files.source_team remote_files.user_team = files.source_team remote_files.source_team = files.user_team remote_files.user_team = files.user_team remote_files.user = files.user
messages	remote_files.channels = messages.channel_id remote_files.pinned_to = messages.channel_id remote_files.channels = messages.pinned_to remote_files.pinned_to = messages.pinned_to remote_files.source_team = messages.bot_profile.team_id remote_files.user_team = messages.bot_profile.team_id remote_files.source_team = messages.team remote_files.user_team = messages.team remote_files.source_team = messages.source_team remote_files.user_team = messages.source_team remote_files.source_team = messages.user_team remote_files.user_team = messages.user_team remote_files.user = messages.reply_users remote_files.user = messages.reactions.users remote_files.user = messages.user
threads	remote_files.channels = threads.channel_id remote_files.pinned_to = threads.channel_id remote_files.source_team = threads.team remote_files.user_team = threads.team remote_files.user = threads.user remote_files.user = threads.reply_users
user_groups	remote_files.groups = user_groups.id remote_files.groups = user_groups.parent_group remote_files.user = user_groups.members remote_files.user = user_groups.purpose.creator remote_files.user = user_groups.topic.creator
teams	remote_files.source_team = teams.id remote_files.user_team = teams.id
users	remote_files.source_team = users.team_id remote_files.user_team = users.team_id remote_files.user = users.id

channels

ARRAY

This is a nested data structure.

comments_count

INTEGER

created

DATE-TIME

date_delete

DATE-TIME

display_as_bot

BOOLEAN

editable

BOOLEAN

editor

STRING

external_id

STRING

external_type

STRING

external_url

STRING

filetype

STRING

groups

ARRAY

This is a nested data structure.

has_rich_preview

BOOLEAN

STRING

image_exif_rotation

INTEGER

ims

ARRAY

This is a nested data structure.

is_external

BOOLEAN

is_public

BOOLEAN

is_starred

BOOLEAN

is_tombstoned

BOOLEAN

last_editor

STRING

mimetype

STRING

mode

STRING

name

STRING

non_owner_editable

BOOLEAN

num_stars

INTEGER

original_h

INTEGER

original_w

INTEGER

permalink

STRING

permalink_public

STRING

pinned_info

OBJECT

This is a nested data structure.

pinned_to

ARRAY

This is a nested data structure.

pretty_type

STRING

preview

STRING

public_url_shared

BOOLEAN

size

INTEGER

source_team

STRING

state

STRING

thumb_1024

STRING

thumb_1024_h

INTEGER

thumb_1024_w

INTEGER

thumb_160

STRING

thumb_360

STRING

thumb_360_h

INTEGER

thumb_360_w

INTEGER

thumb_480

STRING

thumb_480_h

INTEGER

thumb_480_w

INTEGER

thumb_64

STRING

thumb_720

STRING

thumb_720_h

INTEGER

thumb_720_w

INTEGER

thumb_80

STRING

thumb_800

STRING

thumb_800_h

INTEGER

thumb_800_w

INTEGER

thumb_960

STRING

thumb_960_h

INTEGER

thumb_960_w

INTEGER

thumb_tiny

STRING

timestamp

DATE-TIME

title

STRING

updated

DATE-TIME

url_private

STRING

url_private_download

STRING

user

STRING

user_team

STRING

username

STRING

teams

The teams table contains info about teams in your Slack workspace.

Replication Method

Full Table

Useful links

Slack API method

Join teams with	on
channels	teams.id = channels.pending_connected_team_ids
files	teams.id = files.source_team teams.id = files.user_team
messages	teams.id = messages.bot_profile.team_id teams.id = messages.team teams.id = messages.source_team teams.id = messages.user_team
remote_files	teams.id = remote_files.source_team teams.id = remote_files.user_team
threads	teams.id = threads.team
users	teams.id = users.team_id

archived

BOOLEAN

avatar_base_url

STRING

created

DATE-TIME

date_create

DATE-TIME

deleted

DATE-TIME

description

STRING

discoverable

STRING

domain

STRING

email_domain

STRING

enterprise_id

STRING

enterprise_name

STRING

has_compliance_export

BOOLEAN

icon

OBJECT

This is a nested data structure:

image_102: STRING
image_132: STRING
image_230: STRING
image_34: STRING
image_44: STRING
image_68: STRING
image_88: STRING
image_default: BOOLEAN

STRING

is_assigned

BOOLEAN

is_enterprise

INTEGER

messages_count

INTEGER

msg_edit_window_mins

INTEGER

name

STRING

over_integrations_limit

BOOLEAN

over_storage_limit

BOOLEAN

plan

STRING

threads

The threads table contains info about conversation threads in your Slack team.

While this table uses Full Table, it’s not truly replicated in full during each replication job. Each time a message in a thread is updated, the entire thread and all the messages it contains will be replicated in full. This means that while only updated threads are replicated, they are replicated in full whenever they’re updated.

Replication Method

Full Table

Primary Keys

channel_id

thread_ts

Useful links

Slack documentation

Slack API method

Join threads with	on
channels	threads.channel_id = channels.id threads.team = channels.pending_connected_team_ids threads.user = channels.creator threads.reply_users = channels.creator threads.user = channels.members threads.reply_users = channels.members
channel_members	threads.channel_id = channel_members.channel_id threads.user = channel_members.user_id threads.reply_users = channel_members.user_id
files	threads.channel_id = files.channels threads.channel_id = files.pinned_to threads.team = files.source_team threads.team = files.user_team threads.user = files.user threads.reply_users = files.user
messages	threads.channel_id = messages.channel_id threads.channel_id = messages.pinned_to threads.team = messages.bot_profile.team_id threads.team = messages.team threads.team = messages.source_team threads.team = messages.user_team threads.user = messages.reply_users threads.reply_users = messages.reply_users threads.user = messages.reactions.users threads.reply_users = messages.reactions.users threads.user = messages.user threads.reply_users = messages.user
remote_files	threads.channel_id = remote_files.channels threads.channel_id = remote_files.pinned_to threads.team = remote_files.source_team threads.team = remote_files.user_team threads.user = remote_files.user threads.reply_users = remote_files.user
teams	threads.team = teams.id
users	threads.team = users.team_id threads.user = users.id threads.reply_users = users.id
user_groups	threads.user = user_groups.members threads.reply_users = user_groups.members threads.user = user_groups.purpose.creator threads.reply_users = user_groups.purpose.creator threads.user = user_groups.topic.creator threads.reply_users = user_groups.topic.creator

blocks

ARRAY

This is a nested data structure:

type: STRING

channel_id

STRING

client_msg_id

STRING

latest_reply

STRING

reply_count

INTEGER

reply_users

ARRAY

This is a nested data structure.

reply_users_count

NUMBER

subscribed

BOOLEAN

team

STRING

text

STRING

thread_ts

STRING

DATE-TIME

type

STRING

user

STRING

user_groups

The user_groups table contains info about user groups from your Slack team.

Replication Method

Full Table

Primary Key

Useful links

Slack API method

Join user_groups with	on
files	user_groups.id = files.groups user_groups.parent_group = files.groups user_groups.members = files.user user_groups.purpose.creator = files.user user_groups.topic.creator = files.user
remote_files	user_groups.id = remote_files.groups user_groups.parent_group = remote_files.groups user_groups.members = remote_files.user user_groups.purpose.creator = remote_files.user user_groups.topic.creator = remote_files.user
channel_members	user_groups.members = channel_members.user_id user_groups.purpose.creator = channel_members.user_id user_groups.topic.creator = channel_members.user_id
channels	user_groups.members = channels.creator user_groups.purpose.creator = channels.creator user_groups.topic.creator = channels.creator user_groups.members = channels.members user_groups.purpose.creator = channels.members user_groups.topic.creator = channels.members
messages	user_groups.members = messages.reply_users user_groups.purpose.creator = messages.reply_users user_groups.topic.creator = messages.reply_users user_groups.members = messages.reactions.users user_groups.purpose.creator = messages.reactions.users user_groups.topic.creator = messages.reactions.users user_groups.members = messages.user user_groups.purpose.creator = messages.user user_groups.topic.creator = messages.user
threads	user_groups.members = threads.user user_groups.purpose.creator = threads.user user_groups.topic.creator = threads.user user_groups.members = threads.reply_users user_groups.purpose.creator = threads.reply_users user_groups.topic.creator = threads.reply_users
users	user_groups.members = users.id user_groups.purpose.creator = users.id user_groups.topic.creator = users.id

created

DATE-TIME

creator

STRING

is_archived

BOOLEAN

is_deleted

BOOLEAN

is_group

BOOLEAN

is_moved

INTEGER

is_mpim

BOOLEAN

is_open

BOOLEAN

is_pending_ext_shared

BOOLEAN

is_read_only

BOOLEAN

is_thread_only

BOOLEAN

last_read

DATE-TIME

members

ARRAY

This is a nested data structure.

name

STRING

name_normalized

STRING

num_members

INTEGER

parent_group

STRING

priority

NUMBER

purpose

OBJECT

This is a nested data structure:

creator: STRING
last_set: INTEGER
value: STRING

topic

OBJECT

This is a nested data structure:

creator: STRING
last_set: INTEGER
value: STRING

unread_count

INTEGER

unread_count_display

INTEGER

users

The users table lists contains info about the users in your Slack team. This includes deactivated and deleted users.

Replication Method	CDC
Primary Key	id
Replication Key	updated
Useful links	Slack API method

Join users with	on
channels	users.team_id = channels.pending_connected_team_ids users.id = channels.creator users.id = channels.members
files	users.team_id = files.source_team users.team_id = files.user_team users.id = files.user
messages	users.team_id = messages.bot_profile.team_id users.team_id = messages.team users.team_id = messages.source_team users.team_id = messages.user_team users.id = messages.reply_users users.id = messages.reactions.users users.id = messages.user
remote_files	users.team_id = remote_files.source_team users.team_id = remote_files.user_team users.id = remote_files.user
teams	users.team_id = teams.id
threads	users.team_id = threads.team users.id = threads.user users.id = threads.reply_users
channel_members	users.id = channel_members.user_id
user_groups	users.id = user_groups.members users.id = user_groups.purpose.creator users.id = user_groups.topic.creator

color

STRING

deleted

BOOLEAN

has_2fa

BOOLEAN

STRING

is_admin

BOOLEAN

is_app_user

BOOLEAN

is_bot

BOOLEAN

is_owner

BOOLEAN

is_primary_owner

BOOLEAN

is_restricted

BOOLEAN

is_ultra_restricted

BOOLEAN

name

STRING

profile

OBJECT

This is a nested data structure:

email: STRING

real_name

STRING

team_id

STRING

tz_label

STRING

tz_offset

INTEGER

updated

DATE-TIME

Hai trovato utile questa pagina?

Se riscontri problemi con questa pagina o con il suo contenuto – un errore di battitura, un passaggio mancante o un errore tecnico – ti pregiamo di farcelo sapere!

Lascia qui il tuo feedback