Skip to content
Changelog

Report a bug

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.

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).

See How connections work for access and permissions, or browse all integrations.