BizTalk Adapter for Slack

Build 20.0.7654

Reminders

Create, delete, and query all reminders by or for a given user.

Select

The {i uses the Slack API to process search criteria that refer to the Id column while other filters are processed client-side within the {i. 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654