BizTalk Adapter for Slack

Build 20.0.7654

Messages

Create, update, delete, and query the available messages in Slack.

Select

The Messages table requires ChannelId or SearchTerm in the WHERE clause. The 本製品 also uses the Slack API to process search criteria that refer to the Id column. The ChannelId, SearchTerm, and Id columns support server-side processing for the = operator. The 本製品 processes other search criteria client-side within the 本製品.

SELECT * FROM Messages WHERE ChannelId = 'D71R6CSR1'
SELECT * FROM Messages WHERE SearchTerm = 'text' 
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

Slack allows inserts only when ChannelId and Text are specified.

INSERT INTO Messages (ChannelId, Text) VALUES ('D71R6CSR1', 'This is a message')

Update

The Messages table allows updates only for the Text field. Specify ChannelId and Id.

UPDATE Messages Set Text = 'Updated message' WHERE ChannelId = 'D71R6CSR1' AND Id = '1234567890.123456' 

Delete

Messages can be deleted by providing the ChannelId and the Id of the message.

DELETE FROM Messages WHERE ChannelId = 'D71R6CSR1' AND Id = '1234567890.123456 

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Id of the message.

ChannelId [KEY] String False

The Id of the channel the message was posted to.

UserId String True

The Id of the user that posted the message.

Text String False

Text of the message.

AttachmentsAggregate String True

Attachments made to the message.

Previous2MessageId String True

Id of the message before the previous message in the thread of the returned record.

PreviousMessageId String True

Id of the message previous to the returned record.

NextMessageId String True

Id of the following message in the thread of the returned record.

Next2MessageId String True

Id of the message after the following message in the thread of the returned record.

SearchTerm String True

Filter by this column to retrieve all mesages that contain the word in the criteria.

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