ComplianceGroupMembers
Returns the members of compliance groups. Specify GroupId to query one group, or omit it to source group IDs from ComplianceGroups and query each group.
View-Specific Information
Select
If GroupId is omitted, the connector can source group Ids from ComplianceGroups and query each group.
The connector uses the Claude Compliance API to process WHERE clause conditions built with the following column and operator server-side. The rest of the filter, including sorting, grouping, and offsets, is processed client-side within the connector.
- GroupId supports the following operator: =.
- LIMIT
SELECT UserId, Email FROM ComplianceGroupMembers WHERE GroupId = 'group_123' LIMIT 100;
Columns
| Name | Type | Description |
| UserId [KEY] | String | The identifier of the member user. |
| GroupId [KEY] | String | The identifier of the group. Filterable with =. Obtain it from ComplianceGroups.Id to query one group; when omitted, the provider queries each group. The provider copies the SQL criterion into each row because the response does not repeat the parent group Id. |
| String | The email address of the member. | |
| CreatedAt | Datetime | The timestamp at which the member was added. |
| UpdatedAt | Datetime | The last-updated timestamp of the membership. |