SendScheduleMessage
Schedules a message to be sent to 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 SendScheduleMessage Channel = 'D064Q184VGA', PostAt = '2024-07-27 08:20:27.0', Text = 'test message', ReplyBroadCast = true
Input
| Name | Type | Description |
| Channel | String | Channel, private group, or DM channel to send message to. Can be an encoded ID, or a name. |
| PostAt | Datetime | The datetime representing the future time the message should post to Slack. |
| 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. |
| LinkNames | Boolean | Find and link user groups. No longer supports linking individual users; use syntax shown in Mentioning Users instead. |
| Metadata | String | JSON object with event_type and event_payload fields, presented as a URL-encoded string. Metadata you post to Slack is accessible to any app or user who is a member of that workspace. |
| Parse | String | Change how messages are treated. Value should be one of none or full.
The allowed values are none, full. |
| ReplyBroadCast | Boolean | Used in conjunction with thread_ts and indicates whether reply should be made visible to everyone in the channel or conversation. Defaults to false. |
| 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. |
| UnfurlLinks | Boolean | Pass true to enable unfurling of primarily text-based content. |
| UnfurlMedia | Boolean | Pass false to disable unfurling of media content. |
Result Set Columns
| Name | Type | Description |
| Success | String | The result of the procedure. |