Retrieve members of a conversation.

Select

You must specify the ChannelId column in the WHERE clause to query the ConversationMembers view.

The add-in uses the Slack API to process search criteria that refer to the ChannelId column. This column supports server-side processing for the = operator. The add-in processes other filters client-side within the add-in.

For example, the following query is processed server-side:

SELECT * FROM ConversationMembers WHERE ChannelId = 'C01KWCPJJ68'

Delete

Members can be removed from the conversation by specifying the ChannelId and MemberId.

DELETE FROM ConversationMembers WHERE ChannelId = 'D71R6CSR1' AND MemberId = 'U03AZBU3CMT' 

Columns