n8n

N8n DataTable API

Operations about data tables and their rows

Documentation GitHub OpenAPI

Operations 13

GET /data-tables List all data tables #

POST /data-tables Create a data table #

GET /data-tables/{dataTableId} Get a data table #

DELETE /data-tables/{dataTableId} Delete a data table #

PATCH /data-tables/{dataTableId} Update a data table #

GET /data-tables/{dataTableId}/rows List rows in a data table #

POST /data-tables/{dataTableId}/rows Insert rows into a data table #

POST /data-tables/{dataTableId}/rows/update Update rows in a data table #

POST /data-tables/{dataTableId}/rows/upsert Upsert rows in a data table #

POST /data-tables/{dataTableId}/rows/delete Delete rows in a data table #

GET /data-tables/{dataTableId}/columns List columns in a data table #

POST /data-tables/{dataTableId}/columns Add a column to a data table #

DELETE /data-tables/{dataTableId}/columns/{columnId} Delete a column from a data table #

Work with this as data

Every API 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 apis

7 MCP tools reach this

find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
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.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/n8n-datatable-api"

All apis

curl "https://apis.io/api/v1/apis?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.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.2.0
info:
  title: n8n Public Audit Data Table API
  description: The n8n public REST API provides programmatic access to n8n instance resources including workflows, executions, credentials, users, tags, variables, projects, source control, audit, data tables, community packages, folders, and insights.
  termsOfService: https://n8n.io/legal/#terms
  contact:
    name: n8n
    url: https://n8n.io/
    email: hello@n8n.io
  license:
    name: Sustainable Use License
    url: https://github.com/n8n-io/n8n/blob/master/LICENSE.md
  version: 1.1.1
servers:
- url: https://app.n8n.cloud/api/v1
  description: n8n Cloud
- url: '{baseUrl}/api/v1'
  description: Self-hosted n8n
  variables:
    baseUrl:
      default: http://localhost:5678
security:
- ApiKeyAuth: []
- BearerAuth: []
tags:
- name: DataTable
  description: Operations about data tables and their rows
paths:
  /data-tables:
    get:
      tags:
      - DataTable
      summary: List all data tables
      operationId: listDataTables
      responses:
        '200':
          description: Operation successful.
    post:
      tags:
      - DataTable
      summary: Create a data table
      operationId: createDataTable
      responses:
        '201':
          description: Created
  /data-tables/{dataTableId}:
    get:
      tags:
      - DataTable
      summary: Get a data table
      operationId: getDataTable
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Operation successful.
    delete:
      tags:
      - DataTable
      summary: Delete a data table
      operationId: deleteDataTable
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '204':
          description: Deleted
    patch:
      tags:
      - DataTable
      summary: Update a data table
      operationId: updateDataTable
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Operation successful.
  /data-tables/{dataTableId}/rows:
    get:
      tags:
      - DataTable
      summary: List rows in a data table
      operationId: listDataTableRows
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Operation successful.
    post:
      tags:
      - DataTable
      summary: Insert rows into a data table
      operationId: insertDataTableRows
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '201':
          description: Created
  /data-tables/{dataTableId}/rows/update:
    post:
      tags:
      - DataTable
      summary: Update rows in a data table
      operationId: updateDataTableRows
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Operation successful.
  /data-tables/{dataTableId}/rows/upsert:
    post:
      tags:
      - DataTable
      summary: Upsert rows in a data table
      operationId: upsertDataTableRows
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Operation successful.
  /data-tables/{dataTableId}/rows/delete:
    post:
      tags:
      - DataTable
      summary: Delete rows in a data table
      operationId: deleteDataTableRows
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Operation successful.
  /data-tables/{dataTableId}/columns:
    get:
      tags:
      - DataTable
      summary: List columns in a data table
      operationId: listDataTableColumns
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Operation successful.
    post:
      tags:
      - DataTable
      summary: Add a column to a data table
      operationId: addDataTableColumn
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      responses:
        '201':
          description: Created
  /data-tables/{dataTableId}/columns/{columnId}:
    delete:
      tags:
      - DataTable
      summary: Delete a column from a data table
      operationId: deleteDataTableColumn
      parameters:
      - name: dataTableId
        in: path
        required: true
        schema:
          type: string
      - name: columnId
        in: path
        required: true
        schema:
          type: string
      responses:
        '204':
          description: Deleted
components:
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: header
      name: X-N8N-API-KEY
    BearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
externalDocs:
  description: n8n API documentation
  url: https://docs.n8n.io/api/