Introduction

Enzo Server
  Installation
  Quick Start
  Core Features
    Async Calls
    ConnectionStrings
    Edge Cache
    HTTP Access
    Scheduling
    Views
  Advanced Capabilities
    Change Data Capture
  Administration
    Configuration Settings
    Logins & ACL
    Auditing
    Current Executions
    Linked Server
    SSL

  User Guides
     Sharding
     Sharding Overview

     SharePoint

   Adapters
    All Adapters
    ActiveCampaign
    Azure Bus
    Azure IoT Hub
    Azure Key Vault
    Azure Storage
    Bing Search
    ConstantContact
    CouchbaseDB
    CSV
    DB (RDBMS)
    Dropbox
    Files
    Flight Aware
    FreshBooks
    FTP
    Geonames
    GoogleDrive
    GoogleSearch
    GoogleSheet
    GreenMile
    GpsInsight
    HttpEndpoint (REST)
    Intacct
    Insteon
    Loggly
    MailChimp
    Messaging (SMS/SMTP)
    MongoDB
    Motus
    MSAD
    MSMQ
    OneDrive
    OneDrive365 (Business)
    Pipeline
    Pressero
    RabbitMQ
    SalesForce
    Shard
    SharePoint
    Slack
    SQL Server
    SQLX
    Sudoku
    Teams
    Threading
    Twilio
    Twitter
    VellemanDMX
    Whiparound
    WMI
    Xls (Excel)
    ZIP


  SDK
    Overview
    Installation
    DevHost
    Create A Simple Adapter
    Handler Columns

    Advanced SDK Concepts
      Handler Decorators
      Dynamic Columns
      Table & Table Enumerators
      Virtual Tables

/adapters/slack




Slack


The Slack adapter allows you to manage Slack Channels, send/receive messages to Channels or directly to users, and view users that belong to existing channels.

Download the Slack API signup instructions

Configuration Settings



Name Description Default
Boolean _isDefault Make this the default configuration. Defaults to true if configName is already the default.
String accessToken accessToken is used for authenticate with Slack
String clientId the clientId is useful to authenticate
String clientSecret the client secret key

Handlers



archiveChannel
archive
Archive channel from slack details 

Arguments

Name Description Default
channelId R

SQL Call

EXEC Slack.archiveChannel 'channedId' 
delete from Slack.archive where channelId=''


Http Call

/bsc/slack/archivechannel

Output Columns

This call does not return data.

archiveChannelEx
archiveEx
Archive channel from slack details 

Arguments

Name Description Default
configName
channelId R

SQL Call

EXEC Slack.archiveChannelEx 'config1', 'channedId' 
delete from Slack.archiveEx@configName where channelId=''


Http Call

/bsc/slack/archivechannelex

Output Columns

This call does not return data.

createChannel
channels
Create new channels from slack details 

Arguments

Name Description Default
name R

SQL Call

EXEC Slack.createChannel 'abc' 
Insert into Slack.channels (name)values('Channel1')


Http Call

/bsc/slack/createchannel

Output Columns

String Name
String Id
createChannelEx
channelsEx
Create new channels from slack details 

Arguments

Name Description Default
configName
name R

SQL Call

EXEC Slack.createChannelEx 'config1','abc' 
Insert into Slack.channelsEx@configName (name)values('Channel1')


Http Call

/bsc/slack/createchannelex

Output Columns

String Name
String Id
getAuthURL
authURL
Get Authentication url details 

Arguments


SQL Call

EXEC Slack.getAuthURL
SELECT * FROM Slack.authURL


Http Call

/bsc/slack/getauthurl

Output Columns

String url
getAuthURLEx
authURLEx
Get Authentication url details 

Arguments

Name Description Default
configName

SQL Call

EXEC Slack.getAuthURLEx 'Config1'
SELECT * FROM Slack.authURLEx@configname


Http Call

/bsc/slack/getauthurlex

Output Columns

String url
getTokens
tokens
Get authentication token details 

Arguments

Name Description Default
responseCode R
redirectUri http://localhost

SQL Call

EXEC Slack.getTokens 'code here from getAuthURL Function'
SELECT * FROM Slack.tokens where codeResponse='code here from getAuthURL Function'


Http Call

/bsc/slack/gettokens

Output Columns

String code
String accessToken
String scope
String teamId
getTokensEx
tokensEx
Get authentication token details 

Arguments

Name Description Default
configName
responseCode R
redirectUri http://localhost

SQL Call

EXEC Slack.getTokensEx 'Config1','code here from getAuthURL Function'
SELECT * FROM Slack.tokensEx@configname where codeResponse='code here from getAuthURL Function'


Http Call

/bsc/slack/gettokensex

Output Columns

String code
String accessToken
String scope
String teamId
inviteUser
User
Read all the channel users from slack workspace details 

Arguments

Name Description Default
channelId R
userId R

SQL Call

EXEC Slack.inviteUser 'ChannelId','userId'
insert into Slack.User(userId) values('userId') where channelId = ''


Http Call

/bsc/slack/inviteuser

Output Columns

This call does not return data.

inviteUserEx
UserEx
Read all the channel users from slack workspace details 

Arguments

Name Description Default
configName

SQL Call

EXEC Slack.inviteUserEx 'ChannelId','userId'
insert into Slack.UserEx(userId) values('userId') where channelId = ''


Http Call

/bsc/slack/inviteuserex

Output Columns

String channelIdthe channel Id to invite users of this channel
String userIdthe user Id to invite in channel
listChannels
Channels
Read all the channels from slack details 

Arguments

Name Description Default
topn

SQL Call

EXEC Slack.listChannels 
SELECT * FROM Slack.Channels


Http Call

/bsc/slack/listchannels

Output Columns

String name
DateTime createdDate
String id
DateTime lastReadDate
Int32 numMembers
Int32 unreadCount
Boolean isPrivate
listChannelsEx
ChannelsEx
Read all the channels from slack details 

Arguments

Name Description Default
configName
topn

SQL Call

EXEC Slack.listChannelsEx 'config1'
SELECT * FROM Slack.ChannelsEx@configName
SELECT * FROM Slack.[ChannelsEx@configName]


Http Call

/bsc/slack/listchannelsex

Output Columns

String name
DateTime createdDate
String id
DateTime lastReadDate
Int32 numMembers
Int32 unreadCount
Boolean isPrivate
listChannelUsers
channelUsers
Read all the channel users from slack workspace details 

Arguments

Name Description Default
channelId R

SQL Call

EXEC Slack.listChannelUsers 
SELECT * FROM Slack.channelUsers


Http Call

/bsc/slack/listchannelusers

Output Columns

String Name
String Id
String team_id
listChannelUsersEx
channelUsersEx
Read all the channel users from slack workspace details 

Arguments

Name Description Default
configName
channelId R

SQL Call

EXEC Slack.listChannelUsers 
SELECT * FROM Slack.channelUsers


Http Call

/bsc/slack/listchannelusersex

Output Columns

String Name
String Id
String team_id
listUsers
users
Read all the users from slack workspace details 

Arguments

Name Description Default
topn

SQL Call

EXEC Slack.listUsers 
SELECT * FROM Slack.users


Http Call

/bsc/slack/listusers

Output Columns

String name
String real_name
String id
String team_Id
Boolean is_Admin
Boolean is_owner
Boolean is_bot
String tz
String tz_label
Int32 tz_offset
listUsersEx
usersEx
Read all the users from slack workspace details 

Arguments

Name Description Default
configName
topn

SQL Call

EXEC Slack.listUsersEx 'Config1'
SELECT * FROM Slack.usersEx@Config1


Http Call

/bsc/slack/listusersex

Output Columns

String name
String real_name
String id
String team_Id
Boolean is_Admin
Boolean is_owner
Boolean is_bot
String tz
String tz_label
Int32 tz_offset
postMessage
messages
Post messages to channel from slack details 

Arguments

Name Description Default
channelId R
message R

SQL Call

EXEC Slack.postMessage 'Test msg','channedId' 
Insert into Slack.messages (message) values('Test') where channelId=''


Http Call

/bsc/slack/postmessage

Output Columns

This call does not return data.

postMessageEx
messagesEx
Post messages to channel from slack details 

Arguments

Name Description Default
configName
channelId R
message R

SQL Call

EXEC Slack.postMessageEx 'config1','Test msg','channedId' 
Insert into Slack.messagesEx@configName (message) values('Test') where channelId=''


Http Call

/bsc/slack/postmessageex

Output Columns

This call does not return data.

readMessages
messages
Read channel messages from slack details 

Arguments

Name Description Default
channelId R
latest
oldest
topn

SQL Call

EXEC Slack.readMessages 'channedId' 
SELECT * FROM Slack.messages where channelId='channedId'
SELECT * FROM Slack.messages where channelId='channedId' AND oldest='01/01/2020 06:00:00am'


Http Call

/bsc/slack/readmessages

Output Columns

String channelId
String message
String id
String type
String team
String timestamp
String messageby
String latest
String oldest
readMessagesEx
messagesEx
Read channel messages from slack details 

Arguments

Name Description Default
configName
channelId R
latest
oldest
topn

SQL Call

EXEC Slack.readMessagesEx 'config1','channedId' 
SELECT * FROM Slack.messages where channelId='channedId'
SELECT * FROM Slack.messages where channelId='channedId' AND oldest='01/01/2020 06:00:00am'


Http Call

/bsc/slack/readmessagesex

Output Columns

String channelId
String message
String id
String type
String channel
String timestamp
String messageby
String latest
String oldest
unArchiveChannel
unarchive
Unarchive channel from slack details 

Arguments

Name Description Default
channelId R

SQL Call

EXEC Slack.unArchiveChannel 'channedId' 
delete from Slack.unarchive where channelId=''


Http Call

/bsc/slack/unarchivechannel

Output Columns

This call does not return data.

unArchiveChannelEx
unarchiveEx
Unarchive channel from slack details 

Arguments

Name Description Default
configName
channelId R

SQL Call

EXEC Slack.unArchiveChannelEx 'config1', 'channedId' 
delete from Slack.unarchiveEx@configName where channelId=''


Http Call

/bsc/slack/unarchivechannelex

Output Columns

This call does not return data.