SSIS Components for Slack

Build 24.0.9062

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.

使用できる値は次のとおりです。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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062