Slack is a popular messaging and collaboration platform for teams and organizations.
To set up the pipeline, create a Slack app in your workspace to obtain a user token for accessing the Slack API.
Navigate to your Slack workspace and click on the name at the top-left.
Select Tools > Customize Workspace.
From the top-left Menu, choose Configure apps.
Click Build (top-right) > Create a New App.
Opt for “From scratch”, set the “App Name”, and pick your target workspace.
Confirm with Create App.
Navigate to OAuth and Permissions under the Features section.
Assign the following scopes:
Name | Description |
---|---|
admin |
Administer a workspace |
channels:history |
View messages and other content in public channels |
groups:history |
View messages and other content in private channels |
im:history |
View messages and other content in direct messages |
mpim:history |
View messages and other content in group direct messages |
channels:read |
View basic information about public channels in a workspace |
groups:read |
View basic information about private channels |
im:read |
View basic information about direct messages |
mpim:read |
View basic information about group direct messages |
users:read |
View people in a workspace |
Note: These scopes are adjustable; tailor them to your needs.
From “OAuth & Permissions” on the left, add the scopes and copy the User OAuth Token.
In the YAML file, the configuration section contains the following properties:
Connectorname: Slack
Access_token: Slack Access token
version: 1
encrypt_credentials: false
plugins:
extractors:
- name: Slack_data
connectorname: Slack
config:
access_token: <ACCESS TOKEN>
select:
- TABLE1
- TABLE2
properties:
page_size: <>
start_date: <>
end_date: <>