ConversationMembers
Retrieve members of a conversation.
Select
You must specify the ChannelId column in the WHERE clause to query the ConversationMembers view.
The 本製品 uses the Slack API to process search criteria that refer to the ChannelId column. This column supports server-side processing for the = operator. The 本製品 processes other filters client-side within the 本製品.
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
Name | Type | ReadOnly | Description |
MemberId | String | True |
ID of the member. |
ChannelId | String | True |
ID of the conversation to retrieve members for. |