Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Slack.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Slack, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Slack Stored Procedures
| Name | Description |
| CloseChannel | Closes a direct message or multiperson direct message. |
| DisableUserGroup | Disable an existing User Group. |
| DownloadFile | Downloads a file. |
| EnableUserGroup | Enable a User Group. |
| EndCall | Ends a Call. |
| EndDnd | Ends the current user's Do Not Disturb session immediately. |
| EndSnooze | Ends the current user's snooze mode immediately. |
| GetOAuthAccessToken | Gets an authentication token from Slack. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the auth token from this URL. |
| GetPermaLink | Retrieve a permalink URL for a specific extant message. |
| InviteUser | Invites users to a channel. |
| JoinChannel | Joins an existing conversation. |
| JoinMultipleChannels | Joins the existing muliple channels. |
| LeaveChannel | Leaves a conversation. |
| OpenChannel | Opens or resumes a direct message or multiperson direct message. |
| RefreshOAuthAccessToken | Refresh an authentication token from Slack. |
| RemoveProfilePhoto | Deletes the authenticated user profile photo. |
| SendEphemeralMessage | Sends an ephemeral message to a user in a channel. |
| SendScheduleMessage | Schedules a message to be sent to a channel. |
| SetSnooze | Turns on Do Not Disturb mode for the current user, or changes its duration. |
| ShareMeMessage | Share a me message into a channel. |
| UploadFile | To upload a file. |