BizTalk Adapter for Slack

Build 20.0.7654

Channels

Create, update, and query the available channels in Slack.

Select

The 本製品 will use the Slack API to process search criteria that refer to the Id, IsArchived, IsPublic, IsGroup, IsDirectMessage, and IsMultipartyDirectMessage columns. These columns support server-side processing for the = operator. The 本製品 processes other filters client-side within the 本製品.

For example, the following queries are processed server side by the Slack APIs:

SELECT * FROM Channels WHERE IsPublic = false AND IsGroup = false AND IsArchived = true
 SELECT * FROM Channels WHERE Id = 'D71R6CSR1' 
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

The Name column is the minimum requirement for an insert. Name and IsPublic are the only columns that can be set on an insert.

INSERT INTO Channels (Name, IsPublic) VALUES ('initialname', true)

Update

The Channels table allows updates for columns Name, Purpose, and Topic when Id is specified.

UPDATE Channels SET Topic = 'A Topic Text', Purpose = 'A Purpose Text', Name = 'updatedname' WHERE Id = 'D71R6CSR1' 

Delete

Slack does not allow Channels to be deleted.

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Id of the channel.

Name String False

The name of the channel.

Topic String False

Information about the channel topic.

TopicCreator String True

Creator of the channel topic.

Purpose String False

Information about the channel purpose.

TotalMembers Integer True

Number of members in the channel.

Created Datetime True

Channel creation datetime.

Creator String True

User ID of the member that created this channel.

LastRead Datetime True

The datetime for the last message the calling user has read in this channel.

IsMember Boolean True

Indicates the user or bot user or Slack app associated with the token making the API call is itself a member of the conversation.

IsArchived Boolean True

Indicates a conversation is archived. Frozen in time

IsPublic Boolean False

Indicates whether a conversation is a public channel. Everything said in a public channel can be read by anyone else belonging to a workspace.

IsGroup Boolean True

Indicates whether the channel is a private channel between a group of members.

IsDirectMessage Boolean True

Means the conversation is a direct message between two distinguished individuals or a user and a bot.

IsMultipartyDirectMessage Boolean True

Represents an unnamed private conversation between multiple users.

IsGeneral Boolean True

Means the channel is the workspace's 'general' discussion channel.

Unlinked Integer True

Number of times a link to the channel has been removed.

NameNormalized String True

Normalized name of the channel.

IsShared Boolean True

Means the conversation is in some way shared between multiple workspaces.

IsExtShared Boolean True

Represents this conversation as being part of a Shared Channel with a remote organization.

IsOrgShared Boolean True

Explains whether this shared channel is shared between Enterprise Grid workspaces within the same organization.

IsPendingExtShared Boolean True

It means the conversation is ready to become an IsExtShared channel but isn't quite ready yet and needs some kind of approval or sign off.

PreviousNames String True

A list of previous names this channel has had.

Locale String True

Locale of the channel.

User String True

IsUserDeleted Boolean True

Priority Integer True

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