Reminders
Create, delete, and query all reminders by or for a given user.
Select
The driver uses the Slack API to process search criteria that refer to the Id column while other filters are processed client-side within the driver. For example, the following query is processed server side:
SELECT * FROM Reminders WHERE Id = 'RT7U7LN6F'You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.
Insert
Inserts are allowed when you specify the Text and Time for the reminder. You can also add UserId. For example:
INSERT INTO Reminders (Text, Time, UserId) VALUES ('Remind me for coffee', '2017-01-01 10:00', 'U723764DF')
Update
Slack does not support the update of reminders.
Delete
You can delete a reminder by providing the Id.
DELETE FROM Reminders WHERE Id = 'R71R6CSR1'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
The Id of the reminder. |
Creator | String | True |
The Id of the user who created the reminder. |
UserId | String | False |
The Id of the user the reminder is set for. |
Text | String | False |
The content of the reminder. |
Recurring | Boolean | True |
Indicates if this reminder is to be repeated. |
Time | Datetime | False |
The datetime of the reminder. |
CompleteTimestamp | Datetime | True |
The datetime when the reminder was completed. |