Slack is a popular messaging and collaboration platform for teams and organizations.
To set up the pipeline, you need to create a Slack app in your workspace in order to obtain a user token for accessing the Slack API.
Go 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 on Build (top-right) > Create a New App.
Choose “From scratch”, enter the “App Name”, and select your target workspace.
Confirm by clicking on Create App.
Go 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 fit your needs.
From the “OAuth & Permissions” section 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: <>