Reminders
Create, delete, and query all reminders by or for a given user.
Select
The cmdlet uses the Slack API to process search criteria that refer to the Id column while other filters are processed client-side within the cmdlet. 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 the 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 | References | Description |
| Id [KEY] | String | True |
The Id of the reminder. | |
| Creator | String | True |
Users.Id |
The Id of the user who created the reminder. |
| UserId | String | False |
Users.Id |
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. |