PLATFORMS SOLUTIONS BLOGS CONTACT ☰

Slack Adapter



This adapter allows you to access Slack channels and messages from SQL Server directly, and through REST commands.


This adapter requires a Slack account to be configured

Want to try it in Azure? Click here to learn more or click here to create a new Enzo Server RTM 3.1 Azure VM now.
Want to try it in AWS? Click here to learn more or click here to create a new Enzo Server RTM 3.1 AWS VM now.


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.








601 21st St Suite 300
Vero Beach, FL 32960
United States

(561) 921-8669
info@enzounified.com
terms of service
privacy policy

PLATFORM

ENZO SERVER
ENZO DATAZEN

SOLUTIONS

SOLUTIONS OVERVIEW
INTEGRATION
SaaS
CLOUD ANALYTICS

RESOURCES

DOWNLOAD
BLOGS & VIDEOS
IN THE NEWS
ENZO ADAPTERS
ONLINE DOCUMENTATION
TCO CALCULATOR

COMPANY

LEADERSHIP TEAM
PARTNERS


© 2023 - Enzo Unified