Airtable · Schema
Airtable User
An Airtable user account within an enterprise organization. Users have identity attributes, management states, and permission levels across workspaces and bases.
ApplicationCollaborationDataDatabasesLow-CodeProductivitySpreadsheets
Properties
| Name | Type | Description |
|---|---|---|
| id | string | The unique identifier for the user (starts with 'usr'). |
| string | The email address of the user. | |
| name | string | The display name of the user. |
| state | string | The management state of the user within the enterprise. |
| isAdmin | boolean | Whether the user has enterprise administrator privileges. |
| createdTime | string | The time when the user account was created. |
| lastActivityTime | stringnull | The time of the user's most recent activity. Null if the user has never been active. |
| collaborations | object | The user's collaboration details across workspaces, bases, and interfaces. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://schemas.airtable.com/user.json",
"title": "Airtable User",
"description": "An Airtable user account within an enterprise organization. Users have identity attributes, management states, and permission levels across workspaces and bases.",
"type": "object",
"properties": {
"id": {
"type": "string",
"description": "The unique identifier for the user (starts with 'usr').",
"pattern": "^usr[a-zA-Z0-9]+$",
"examples": ["usrABC123def456"]
},
"email": {
"type": "string",
"format": "email",
"description": "The email address of the user."
},
"name": {
"type": "string",
"description": "The display name of the user."
},
"state": {
"type": "string",
"description": "The management state of the user within the enterprise.",
"enum": ["managed", "unmanaged", "deactivated"]
},
"isAdmin": {
"type": "boolean",
"description": "Whether the user has enterprise administrator privileges."
},
"createdTime": {
"type": "string",
"format": "date-time",
"description": "The time when the user account was created."
},
"lastActivityTime": {
"type": ["string", "null"],
"format": "date-time",
"description": "The time of the user's most recent activity. Null if the user has never been active."
},
"collaborations": {
"type": "object",
"description": "The user's collaboration details across workspaces, bases, and interfaces.",
"properties": {
"workspaceCollaborations": {
"type": "array",
"items": {
"type": "object",
"properties": {
"workspaceId": {
"type": "string"
},
"permissionLevel": {
"type": "string",
"enum": ["owner", "creator", "editor", "commenter", "read"]
}
}
}
},
"baseCollaborations": {
"type": "array",
"items": {
"type": "object",
"properties": {
"baseId": {
"type": "string"
},
"permissionLevel": {
"type": "string",
"enum": ["owner", "creator", "editor", "commenter", "read"]
}
}
}
},
"interfaceCollaborations": {
"type": "array",
"items": {
"type": "object",
"properties": {
"baseId": {
"type": "string"
},
"interfaceId": {
"type": "string"
},
"permissionLevel": {
"type": "string"
}
}
}
}
}
}
},
"required": ["id", "email", "state"],
"additionalProperties": false
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/airtable-user"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.