Reminders
Create, delete, and query all reminders by or for a given user.
Select
The 本製品 uses the Slack API to process search criteria that refer to the Id column while other filters are processed client-side within the 本製品. 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')
To insert with recurring patterns like "every_tuesday" and intervals like "in 15 minutes" use Frequency column.
INSERT INTO Reminders (Text, Frequency, UserId) VALUES ('Remind me for coffee', 'every_tuesday', '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. Only non-recurring reminders will return value for this column. |
CompleteTimestamp | Datetime | True |
The datetime when the reminder was completed. Only non-recurring reminders will return value for this column. |
Frequency | String | False |
Recurring frequency of the reminder. Only recurring reminders will return value for this column. Examples for insert: in 15 minutes or every Thursday |
RecurrenceWeekdays | String | True |
Recurring days for the reminder. Only recurring reminders will return value for this column. |