ScheduledMessages

Query all scheduled messages.

Table-Specific Information

SELECT

The connector will use the Slack API to filter by search criteria that refer to the ChannelId, PostAt and TeamId columns. All columns support server-side processing for the = operator, and the PostAt column also supports server-side processing for the >, >=, <, <= operators.

The connector processes other search criteria client-side within the connector.

Note: TeamId is only relevant when you connect with an org-level token. When you connect with a workspace-level token, the Slack API accepts the TeamId but ignores it and returns data for the authenticated workspace. Filtering on an invalid or empty TeamId therefore does not raise an error and does not return an empty result set.

For example, the following queries are processed server side:

SELECT * FROM ScheduledMessages WHERE ChannelId = 'D064Q184VGA'
SELECT * FROM ScheduledMessages WHERE TeamId = 'T01LC4ASB2M'
SELECT * FROM ScheduledMessages WHERE PostAt >= '07-01-2024 00:00:00' and PostAt <= '07-31-2024 00:00:00'

DELETE

Scheduled Messages can be deleted by providing the ChannelId and the Id of the scheduled message.

DELETE FROM ScheduledMessages WHERE ChannelId = 'D71R6CSR1' AND Id = 'Q07SJJT75CN'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the scheduled message.
ChannelId	String	True		The Id of the Channel.
PostAt	Datetime	True		The date the message was posted.
CreatedTime	Datetime	True		The date the message was created.
Text	String	True		The text of the scheduled message.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.