IndividualCollaborators
Retrieves a list of individual collaborators for Airtable bases and workspaces, including their identifiers, contact details, 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 individual collaborators
SELECT * FROM [Information].[IndividualCollaborators];
-- Filter collaborators by base ID
SELECT * FROM [Information].[IndividualCollaborators]
WHERE BaseId = 'appWJ6DP3C7Guh9fS';
Columns
| Name | Type | Description |
| WorkspaceId [KEY] | String | The unique identifier for the Airtable workspace that contains the base and manages overarching access. |
| BaseId [KEY] | String | The unique identifier for the Airtable base to which the collaborator has access. |
| BaseName | String | The display name of the base as shown in the Airtable interface. |
| UserId [KEY] | String | The unique identifier for the collaborator who has been granted permissions. |
| UserEmail | String | The email address associated with the collaborator’s Airtable account. |
| GrantedByUserId | String | The unique identifier of the user who assigned or modified the collaborator’s permissions for the base. |
| PermissionLevel | String | The specific permission level granted to the collaborator for this base, such as read-only, editor, or creator access. |
| IsAccessedFromWorkspace | Boolean | Indicates whether the collaborator’s access to the base is inherited automatically from workspace-level permissions, rather than being granted directly at the base level. |