GroupCollaborators
Retrieves a list of collaborators in a specific Airtable group, including their identifiers, display names, permission levels, and whether base access is granted directly or inherited from workspace permissions.
View-Specific Information
Note: This view is only available to users with an Airtable Enterprise plan.
SELECT Examples
-- Retrieve all group collaborators
SELECT * FROM [Information].[GroupCollaborators];
-- Filter collaborators by base ID
SELECT * FROM [Information].[GroupCollaborators]
WHERE BaseId = 'appWJ6DP3C7Guh9fS';
Columns
| Name | Type | Description |
| WorkspaceId [KEY] | String | The unique identifier for the Airtable workspace that contains the base and defines overarching access permissions. |
| BaseId [KEY] | String | The unique identifier for the Airtable base to which the group has been granted access. |
| BaseName | String | The display name of the base as presented in the Airtable interface. |
| GroupId [KEY] | String | The unique identifier for the group that has been assigned permissions to the base. |
| GroupName | String | The display name of the group as defined within the Airtable workspace. |
| GrantedByUserId | String | The unique identifier of the user who assigned or modified the group’s permissions for the base. |
| PermissionLevel | String | The specific permission level granted to the group for the base, such as read-only, editor, or creator access. |
| IsAccessedFromWorkspace | Boolean | Indicates whether the group’s access to the base is inherited automatically from workspace-level permissions, rather than being granted directly at the base level. |