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'
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 UPDATE for 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. |