ProjectCollaborators
Returns active project role assignments. Principal fields are a discriminated union selected by Type: user, group, organization, or organization_role. Specify ProjectId to query one project, or omit it to source project IDs from Projects and query each project.
View-Specific Information
Select
If ProjectId is omitted, the add-in can source project Ids from Projects and query each project.
The add-in 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 add-in.
- ProjectId supports the following operator: =.
- LIMIT
SELECT ProjectId, Role, Type, UserId, GroupId FROM ProjectCollaborators WHERE ProjectId = 'claude_proj_123' LIMIT 100;
Columns
| Name | Type | Description |
| ProjectId | String | The Id of the project. Filterable with =. Obtain it from Projects.Id to query one project; when omitted, the provider queries each project. The provider copies the SQL criterion into each row because the response does not repeat the parent project Id. |
| GrantedAt | Datetime | When the role assignment was granted. |
| Role | String | The project role granted: owner, admin, editor, or viewer. |
| Type | String | The principal discriminator: user, group, organization, or organization_role. |
| UserId | String | The user principal Id when Type is user; null when the account was deleted or another principal type applies. |
| GroupId | String | The RBAC group Id when Type is group. |
| OrganizationUuid | String | The organization UUID when Type is organization. |
| OrganizationRole | String | The organization-level role when Type is organization_role. |