Slack is a cloud team collaboration service with a number of tools for online calls, file sharing, etc.
Data integration: Skyvia supports importing data to and from Slack, exporting Slack data to CSV files, and replicating Slack data to relational databases.
Backup: Skyvia Backup does not support Slack.
Query: Skyvia Query supports Slack.
Slack-Specific Features and Limitations
Skyvia has the following limitations for Slack:
In the Data Integration product, Slack connections are supported only for packages, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Slack in your package.
- Skyvia supports import operations (DML) for such Slack objects:
- INSERT, UPDATE, DELETE: DirectChannelsHistory, GroupChannelsHistory, MultipartyDirectChannelsHistory, PublicChannelsHistory.
- INSERT, DELETE: Reminders.
- INSERT: GroupChannels, PublicChannels.
- DELETE: FileComments, Files.
- UPDATE: GroupChannelsPurposes, GroupChannelsTopics, PublicChannelsPurposes, PublicChannelsTopics.
- Skyvia supports Replication with Incremental Updates for such Slack objects: DirectChannels, FileComments, Files, GroupChannels, MultipatryDirectChannels, Pins_DirectChannels, Pins_GroupChannels, Pins_MultipartyDirectChannels, Pins_PublicChannels, PublicChannels, RemoteFiles, Stars, Users.
- Skyvia does not support Synchronization for Slack objects.
When creating a Slack connection you simply log in with Slack. The OAuth authentication token is stored on the Skyvia server. Your Slack account login and password are not stored on the Skyvia server.
To create a Slack connection, perform the following steps:
- Click +NEW in the top menu.
- Open the Select Connector page by clicking Connection in the menu on the left.
- In the opened pane, click Slack.
In the Connection Editor page, in the Untitled field, specify a connection name that will be used to identify the connection.
- Optionally, you can select the Suppress Extended Requests checkbox to reduce the number of API calls. However, beforehand read more about this option below.
- Click Sign In with Slack.
In the opened window, enter your Slack workspace name and click the Continue button.
Enter your Slack credentials and click Sign in.
Skyvia will request permission to access Slack workspace. Click Allow to give permission.
- Wait until the necessary data are transmitted and then click Create Connection.
Suppressing Extended Requests
For some objects, Slack API returns only part of the fields when querying multiple records. In order to query values of additional fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such object. However, this can decrease performance and significantly increase the number of API calls used.
To reduce the number of API calls, you can select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in Slack because Slack API does not return them without extended requests.
Supported Actions and Actions Specifics
Slack connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.