NocoDB integration: operations for AI agents
NocoDB connects to Type.com as an integration. This page lists the 114 operations documented for Claude and Codex in Type.com: 39 read, 51 write, 24 destructive.
About NocoDB
Free & open source Airtable alternative. NocoDB turns any database into a smart spreadsheet with REST APIs.
Categories: Developer Tools & IT
How to connect NocoDB to Type.com
- Access
- Organization connection: one shared account for the workspace.
To add the connection, follow the steps in Space connections.
Documented operations
114 operations. Your connection's permissions determine which operations are available. API references describe the vendor surface; they do not expand your connection's credentials or access.
114 operations listed.
Workspaces
- Read
List workspaces
Retrieve a list of all workspaces accessible to the user. Note: Listing and creating workspaces is available on all cloud-hosted plans and on all self-hosted deployments.
- Read
Get workspace
Retrieve details of a specific workspace. Note: This endpoint is available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Create workspace
Create a new workspace with the specified title and optional organization ID. Note: Listing and creating workspaces is available on all cloud-hosted plans and on all self-hosted deployments.
- Write
Update workspace
Update workspace details. Note: This endpoint is available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Destructive
Delete workspace
Delete a workspace. Note: This endpoint is available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
Bases
- Read
List bases
Retrieve a list of bases associated with a specific workspace.
- Read
Get base meta
Retrieve meta details of a specific base using its unique identifier.
- Write
Create base
Create a new base in a specified workspace. The request requires the workspace identifier in the path and base details in the request body.
- Write
Update base
Update properties of a specific base. You can modify fields such as the title and metadata of the base. The baseId parameter identifies the base to be updated, and the new details must be provided in the request body. At least one of title or meta must be provided.
- Destructive
Delete base
Delete a specific base using its unique identifier. Once deleted, the base and its associated data cannot be recovered.
Workspace Members
- Read
List workspace members
Retrieve details of a specific workspace, including its members. Notes: - To include member details, use the query parameter include[]=members.
- Write
Add workspace members
Add new members to a workspace. The request requires the workspace identifier in the path and member details in the request body.
- Write
Update workspace members
Update roles of existing workspace members. The request requires the workspace identifier in the path and member update details in the request body.
- Destructive
Delete workspace members
Remove members from a workspace. The request requires the workspace identifier in the path and member details in the request body.
Tables
- Read
List tables
Retrieve list of all tables within the specified base.
- Read
Get table schema
Retrieve the details of a specific table.
- Write
Create table
Create a new table within the specified base by providing the required table details in the request body.
- Write
Update table
Update the details of a specific table.
- Destructive
Delete table
Delete a specific table.
Views
- Read
List views
Retrieve a list of all views for a specific table. Note: View APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Read
Get view schema
Retrieve the details of a specific view. Note: View APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Write
Create view
Create a view for table. Note: View APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Write
Update view
Update the details of a specific view. The request body should contain the fields to be updated. Fields not included in the request body will remain unchanged. Fields included will overwrite the existing values.
- Destructive
Delete view
Delete a specific view. Note: View APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
Fields
- Read
Get field
Retrieve the details of a specific field.
- Write
Create field
Create a new field within the specified table.
- Write
Update field
Update the details of a specific field.
- Write
Add field options
Add one or more choices (options) to a SingleSelect or MultiSelect field. Existing choices are kept. Titles are trimmed before comparison, and choices whose title already exists on the field are skipped (idempotent).
- Destructive
Delete field
Delete a specific field.
- Destructive
Remove field options
Remove one or more choices (options) from a SingleSelect or MultiSelect field, addressed by title. Titles are matched exactly — they are neither trimmed nor case-folded — and titles not present on the field are ignored (idempotent).
Hooks
- Read
List hooks
Retrieve a list of all hooks for a specific table. Note: Hook APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Read
Get hook
Retrieve the details of a specific hook. Note: Hook APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Create hook
Create a new hook for a table. Note: Hook APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Update hook
Update the details of a specific hook. Note: Hook APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Destructive
Delete hook
Delete a specific hook. Note: Hook APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
View Filters
- Read
List view filters
Retrieve a list of all filters and groups for a specific view.
- Write
Create filter
Create a new filter or filter-group for a specific view. Groups may nest at most three levels deep; a fourth level of nesting is rejected with a 400. A group's id is assigned by the server and must not be supplied.
- Write
Update filter
Update an existing filter or filter-group.
- Destructive
Replace filter
Replace filters for a specific view. All the existing filters will be overwritten with the new filters specified in this request. Groups may nest at most three levels deep; a fourth level of nesting is rejected with a 400.
- Destructive
Delete filter
Delete an existing filter or filter-group.
View Sorts
- Read
List view sorts
Retrieve a list of all sorts for a specific view.
- Write
Add sort
Create a new sort for a specific view.
- Write
Update sort
Update an existing sort.
- Destructive
Delete sort
Delete an existing sort.
Base Members
- Read
List base members
Retrieve all details of a specific base, including its members. Notes: Base collaboration APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Invite base members
Invite new members to a specific base using their User ID or Email address. Notes: Base collaboration APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Update base members
Update roles for existing members in a base. Notes: Base collaboration APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Destructive
Delete base members
Remove members from a specific base using their IDs. Notes: Base collaboration APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
Scripts
- Read
List Scripts
Retrieve a list of scripts associated with a specific base. Note: Script APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Read
Get Script Info
Retrieve the details of a specific script. Note: Script APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Write
Create script
Create a new script within the specified base by providing the required script details in the request body. Note: Script APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Write
Update script
Update the script. Note: Script APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Destructive
Delete script
Delete the script. Note: Script APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
Dashboards
- Read
List Dashboards
Retrieve a list of dashboards in the specified base. Note: Dashboard APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Read
Get Dashboard
Retrieve details of a specific dashboard. Pass include=widgets to include the dashboard's widgets in the response. Note: Dashboard APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Read
Get Dashboard Data
Retrieve data for all widgets in the specified dashboard. Returns a map of widget IDs to their data. Note: Dashboard APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Read
List Widgets
Retrieve a list of widgets in the specified dashboard. Note: Widget APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Read
Get Widget
Retrieve details of a specific widget. Note: Widget APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Read
Get Widget Data
Retrieve data for a specific widget. Note: Widget APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Write
Create Dashboard
Create a new dashboard within the specified base. Note: Dashboard APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Write
Update Dashboard
Update the specified dashboard. Note: Dashboard APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Write
Create Widget
Create a new widget within the specified dashboard. Note: Widget APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Write
Update Widget
Update the specified widget. Note: Widget APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Destructive
Delete Dashboard
Delete the specified dashboard. Note: Dashboard APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
- Destructive
Delete Widget
Delete the specified widget. Note: Widget APIs are available on cloud-hosted Enterprise plans, and on licensed self-hosted deployments (Business plan and above).
Workflows
- Read
List Workflows
Retrieve a list of workflows associated with a specific base. Note: Workflow APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Read
Get Workflow
Retrieve the details of a specific workflow. Note: Workflow APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Read
List Workflow Executions
Retrieve a list of executions for a specific workflow. Note: Workflow APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Read
Get Workflow Execution
Retrieve the details of a specific workflow execution. Note: Workflow APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Execute Workflow
Manually trigger a workflow execution. This endpoint only works for workflows whose trigger type is manual-trigger. Note: Workflow APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
Table Records
- Read
List Table Records
This API endpoint allows you to retrieve records from a specified table. You can customize the response by applying various query parameters for filtering, sorting, and formatting. Pagination: The response is paginated by default, with the first page being returned initially.
- Read
Read Table Record
This API endpoint allows you to retrieve a single record identified by Record-ID, serving as unique identifier for the record from a specified table.
- Read
Count Table Records
This API endpoint allows you to retrieve the total number of records from a specified table or a view. You can narrow down search results by applying where query parameter
- Write
Create Table Records
Create one or more records. Send a single object or an array; the array length is capped per deployment (10 by default) and a longer request answers 422. Link fields accept the related record's id.
- Write
Update Table Records
Update one or more records, addressed by id. Send a single object or an array; the array length is capped per deployment (10 by default) and a longer request answers 422. Only the fields you send are changed.
- Write
Upsert Table Records
Find-or-create records in a single call. If a record matching the merge key exists it is updated, otherwise a new one is inserted.
- Write
Upload Attachment to Cell
Upload one base64-encoded file into an Attachment cell. The file is appended; nothing is replaced. Maximum file size is set per deployment (20 MB by default); the number of files a cell may hold is a plan limit. An oversized file answers 400.
- Write
Trigger Button Action
Triggers a button action (such as AI generation) for specified rows. This is useful for bulk processing button actions programmatically. Maximum of 25 rows can be processed at a time.
- Destructive
Delete Table Records
Delete one or more records, addressed by id. Send a single object or an array, or pass ids in the records query parameter. The count is capped per deployment (10 by default).
Linked Records
- Read
List Linked Records
Retrieves the records linked to a given record through a Link field. The response shape follows the relation type of the link field: - has-many, many-to-many — records, an array of { id, fields } objects, empty when nothing is linked.
- Write
Link Records
This API endpoint allows you to link records to a specific Link field and Record ID. The request payload is an array of record-ids from the adjacent table for linking purposes. Note that any existing links, if present, will be unaffected during this operation.
- Destructive
Unlink Records
This API endpoint allows you to unlink records from a specific Link field and Record ID. The request payload is an array of record-ids from the adjacent table for unlinking purposes. Note that, - duplicated record-ids will be ignored. - non-existent record-ids will be ignored.
Teams
- Read
List Teams
Retrieve a list of teams in a workspace. Note: Team Management is a plan feature. A workspace whose plan does not include it is rejected with 403 on every team operation.
- Read
Get Team
Fetch details of a specific team
- Write
Create Team
Create a new team
- Write
Update Team
Update name, icon, or badge color
- Write
Add Members to Team
Add members to a team
- Write
Update Member Role
Update member roles in a team
- Destructive
Delete Team
Delete a team
- Destructive
Remove Member from Team
Remove members from a team
Environments
- Read
List Environments
Retrieve the effective environment set for a workspace: the built-in production and staging environments (virtual, locked — present for every workspace with no stored row), plus the organization’s shared environments and the workspace’s own custom environments.
- Read
List Organization Environments
Retrieve the organization-level environment set: the built-in production and staging environments (virtual, locked) plus the organization’s own environments.
- Write
Create Environment
Create a custom environment in a workspace. The stable key slug is auto-derived from the title server-side (lowercased, non-alphanumeric runs collapsed to -, capped at 50 characters) and frozen thereafter — clients never send a key.
- Write
Update Environment
Update a custom environment’s title, description, color or order. The key slug is frozen at create time — renaming the title never re-derives it, so references to the environment stay valid.
- Write
Create Organization Environment
Create a custom environment at the organization level, shared by all of the organization’s workspaces. The stable key slug is auto-derived from the title server-side and frozen thereafter — clients never send a key.
- Write
Update Organization Environment
Update an organization environment’s title, description, color or order. The key slug is frozen at create time — renaming the title never re-derives it. The built-in environments (production / staging) cannot be edited. Requires Org Owner role.
- Destructive
Delete Environment
Delete a custom environment. All per-environment integration configuration overrides bound to it are removed as well. The built-in environments (production / staging) cannot be deleted, and org-scoped environments cannot be deleted from the workspace routes.
- Destructive
Delete Organization Environment
Delete an organization environment. All per-environment integration configuration overrides bound to it — across every workspace under the organization — are removed as well. The built-in environments (production / staging) cannot be deleted. Requires Org Owner role.
Feedback
- Write
Submit feedback
Report a NocoDB bug, missing capability, confusing behavior or docs gap. Meant for agents after a failed call (pass the failed response's requestId as evidence.requestId) or when the user asks to send feedback. It changes no data and fixes nothing.
API Tokens
- Read
List API tokens
Retrieve a list of all API tokens for the organization. Note: This endpoint accepts a session credential only. An API token is rejected with 401 ERRAPITOKENNOTALLOWED; an OAuth access token with 403 ERRFORBIDDEN.
- Write
Create API token
Create a new API token for the organization. Note: This endpoint accepts a session credential only. An API token is rejected with 401 ERRAPITOKENNOTALLOWED; an OAuth access token with 403 ERRFORBIDDEN.
- Write
Update API token
Update an API token's title, scopes, expiry or enabled flag. expiry: null clears the expiry. The token value is never returned. A caller who does not own the token gets 404, unless they are a super admin.
- Destructive
Delete API token
Delete an API token by its ID. Note: This endpoint accepts a session credential only. An API token is rejected with 401 ERRAPITOKENNOTALLOWED; an OAuth access token with 403 ERRFORBIDDEN.
Documents
- Read
List documents
Retrieve a list of documents in a base. Documents are returned without content for lightweight listing.
- Read
Get document
Retrieve a single document with its full content (rich-text JSON). Documents APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Create document
Create a new document in a base. If no title is provided, defaults to "Untitled". If no content is provided, defaults to an empty document. To create a child document, pass the parentid of the parent document.
- Write
Update document
Update a document's title, content, or metadata. Optimistic concurrency control: You must include the current version of the document. If the version does not match the server's version (i.e., someone else edited it), the request will be rejected with a 422 error.
- Write
Reorder or move document
Update a document's sort order among its siblings, and optionally move it to a different parent. Order: Pass a float value. To insert between two siblings with orders 2.0 and 3.0, use 2.5 (midpoint). Move: Include parentid to re-parent the document.
- Destructive
Delete document
Soft-delete a document. All child documents are also deleted (cascade). Attachments (images, files) referenced by the document are also cleaned up.
Comments
- Read
List comments
Retrieve all comments for a specific record. Note: Comment APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Create comment
Create a new comment on a record. Note: Comment APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Update comment
Update the text of an existing comment. Only the comment creator can update. Note: Comment APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Write
Resolve comment
Toggle the resolved state of a comment. If already resolved, unresolves it. Note: Comment APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
- Destructive
Delete comment
Soft-delete a comment. Only the comment creator can delete. Note: Comment APIs are available on cloud-hosted Business plans and above, and on licensed self-hosted deployments (Business plan and above).
No operations match.
See How connections work for access and permissions, or browse all integrations.