SendEphemeralMessage
Sends an ephemeral message to a user in a channel.
Stored Procedure Specific Information
Slack allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison. The required scopes to execute this SP is chat:write, chat:write:user and chat:write:bot.
For example:
EXECUTE SendEphemeralMessage ChannelId = 'C01KWCPJJ68', UserId = 'U063F52GHED', Text = 'test message'
Input
| Name | Type | Description |
| ChannelId | String | The ID of the conversation or channel containing the message. |
| UserId | String | Id of the user who will receive the ephemeral message. |
| Text | String | The message that you want to send. |
| Attachments | String | A JSON-based array of structured attachments, presented as a URL-encoded string. |
| Blocks | String | A JSON-based array of structured blocks, presented as a URL-encoded string. |
| AsUser | Boolean | Set to true to post the message as the authed user, instead of as a bot. Defaults to false. Cannot be used by new Slack apps. |
| IconEmoji | String | Pass false to disable unfurling of media content. |
| IconUrl | String | Pass false to disable unfurling of media content. |
| LinkNames | Boolean | Find and link user groups. No longer supports linking individual users; use syntax shown in Mentioning Users instead. |
| Parse | String | Change how messages are treated. Value should be one of none or full.
The allowed values are none, full. |
| ParentMessageId | String | Provide another message's id value to make this message a reply. Avoid using a reply's id value; use its parent instead. |
| Username | String | Pass true to enable unfurling of primarily text-based content. |
Result Set Columns
| Name | Type | Description |
| Success | String | The result of the procedure. |
| MessageId | String | The Id of the message sent. |