ADO.NET Provider for Slack

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062