Data Table

Operations about data tables and their rows

List all data tables

get

Retrieve a list of all data tables with optional filtering, sorting, and pagination.

Authorizations

X-N8N-API-KEYstringRequired

Query parameters

limitnumber · max: 250Optional

The maximum number of items to return.

Default: 100Example: 100

cursorstringOptional

Paginate by setting the cursor parameter to the nextCursor attribute returned by the previous request's response. Default value fetches the first "page" of the collection. See pagination for more detail.

filterstring · jsonStringOptional

JSON string of filter conditions

Example: {"name":"my-table"}

sortBystringOptional

Sort format: field:asc or field:desc

Example: name:asc

Responses

200

Successfully retrieved data tables

application/json

nextCursorstring · nullableOptional

Paginate through data tables by setting the cursor parameter to a nextCursor attribute returned by a previous request. Default value fetches the first "page" of the collection.

Example: MTIzZTQ1NjctZTg5Yi0xMmQzLWE0NTYtNDI2NjE0MTc0MDA

400

The request is invalid or provides malformed data.

401

Unauthorized

get/data-tables

GET /api/v1/data-tables HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Accept: */*

{
  "data": [
    {
      "id": "text",
      "name": "text",
      "columns": [
        {
          "id": "text",
          "name": "text",
          "type": "string",
          "index": 1
        }
      ],
      "projectId": "text",
      "createdAt": "2026-07-19T15:21:28.832Z",
      "updatedAt": "2026-07-19T15:21:28.832Z"
    }
  ],
  "nextCursor": "MTIzZTQ1NjctZTg5Yi0xMmQzLWE0NTYtNDI2NjE0MTc0MDA"
}

Create a new data table

post

Create a new data table in your personal project or a team project you have access to.

Authorizations

X-N8N-API-KEYstringRequired

Body

namestring · min: 1 · max: 128Required

Name of the data table

projectIdstringOptional

ID of the project to create the table in. When omitted, the table is created in the user's personal project.

Responses

201

Data table created successfully

application/json

idstringRequired

Unique identifier for the data table

namestringRequired

Name of the data table

projectIdstringRequired

ID of the project this table belongs to

createdAtstring · date-timeRequired

Timestamp when the table was created

updatedAtstring · date-timeRequired

Timestamp when the table was last updated

400

The request is invalid or provides malformed data.

401

Unauthorized

403

Forbidden

409

Conflict

post/data-tables

POST /api/v1/data-tables HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 130

{
  "name": "customers",
  "columns": [
    {
      "name": "email",
      "type": "string"
    },
    {
      "name": "status",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    }
  ]
}

{
  "id": "text",
  "name": "text",
  "columns": [
    {
      "id": "text",
      "name": "text",
      "type": "string",
      "index": 1
    }
  ],
  "projectId": "text",
  "createdAt": "2026-07-19T15:21:28.832Z",
  "updatedAt": "2026-07-19T15:21:28.832Z"
}

Get a data table

get

Retrieve a specific data table by ID.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Responses

200

Successfully retrieved data table

application/json

idstringRequired

Unique identifier for the data table

namestringRequired

Name of the data table

projectIdstringRequired

ID of the project this table belongs to

createdAtstring · date-timeRequired

Timestamp when the table was created

updatedAtstring · date-timeRequired

Timestamp when the table was last updated

401

Unauthorized

404

The specified resource was not found.

get/data-tables/{dataTableId}

GET /api/v1/data-tables/{dataTableId} HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Accept: */*

{
  "id": "text",
  "name": "text",
  "columns": [
    {
      "id": "text",
      "name": "text",
      "type": "string",
      "index": 1
    }
  ],
  "projectId": "text",
  "createdAt": "2026-07-19T15:21:28.832Z",
  "updatedAt": "2026-07-19T15:21:28.832Z"
}

Delete a data table

delete

Delete a data table. This will also delete all rows in the table.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Responses

204

Data table deleted successfully

No content

401

Unauthorized

404

The specified resource was not found.

delete/data-tables/{dataTableId}

DELETE /api/v1/data-tables/{dataTableId} HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Accept: */*

No content

Update a data table

patch

Update a data table's name.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Body

namestring · min: 1 · max: 128Required

New name for the data table

Responses

200

Data table updated successfully

application/json

idstringRequired

Unique identifier for the data table

namestringRequired

Name of the data table

projectIdstringRequired

ID of the project this table belongs to

createdAtstring · date-timeRequired

Timestamp when the table was created

updatedAtstring · date-timeRequired

Timestamp when the table was last updated

400

The request is invalid or provides malformed data.

401

Unauthorized

404

The specified resource was not found.

409

Conflict

patch/data-tables/{dataTableId}

PATCH /api/v1/data-tables/{dataTableId} HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 28

{
  "name": "updated-customers"
}

{
  "id": "text",
  "name": "text",
  "columns": [
    {
      "id": "text",
      "name": "text",
      "type": "string",
      "index": 1
    }
  ],
  "projectId": "text",
  "createdAt": "2026-07-19T15:21:28.832Z",
  "updatedAt": "2026-07-19T15:21:28.832Z"
}

Retrieve rows from a data table

get

Query and retrieve rows from a data table with optional filtering, sorting, and pagination.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Query parameters

limitnumber · max: 250Optional

The maximum number of items to return.

Default: 100Example: 100

cursorstringOptional

filterstring · jsonStringOptional

JSON string of filter conditions

Example: {"type":"and","filters":[{"columnName":"status","condition":"eq","value":"active"}]}

sortBystringOptional

Sort format: columnName:asc or columnName:desc

Example: createdAt:desc

searchstringOptional

Search text across all string columns

Responses

200

Successfully retrieved rows

application/json

nextCursorstring · nullableOptional

Paginate through rows by setting the cursor parameter to a nextCursor attribute returned by a previous request. Default value fetches the first "page" of the collection.

Example: MTIzZTQ1NjctZTg5Yi0xMmQzLWE0NTYtNDI2NjE0MTc0MDA

400

The request is invalid or provides malformed data.

401

Unauthorized

404

The specified resource was not found.

get/data-tables/{dataTableId}/rows

GET /api/v1/data-tables/{dataTableId}/rows HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Accept: */*

{
  "data": [
    {
      "id": 1,
      "createdAt": "2026-07-19T15:21:28.832Z",
      "updatedAt": "2026-07-19T15:21:28.832Z",
      "ANY_ADDITIONAL_PROPERTY": "anything"
    }
  ],
  "nextCursor": "MTIzZTQ1NjctZTg5Yi0xMmQzLWE0NTYtNDI2NjE0MTc0MDA"
}

Insert rows into a data table

post

Insert one or more rows into a data table.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Body

returnTypestring · enumOptional

count: Return only the number of rows inserted
id: Return an array of inserted row IDs
all: Return the full row data for all inserted rows

Default: countPossible values:

Responses

200

Rows inserted successfully

application/json

integer[]Optional

Array of inserted row IDs (when returnType is 'id')

400

The request is invalid or provides malformed data.

401

Unauthorized

404

The specified resource was not found.

post/data-tables/{dataTableId}/rows

POST /api/v1/data-tables/{dataTableId}/rows HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 143

{
  "data": [
    {
      "name": "John Doe",
      "email": "john@example.com",
      "age": 30
    },
    {
      "name": "Jane Smith",
      "email": "jane@example.com",
      "age": 25
    }
  ],
  "returnType": "all"
}

{
  "count": 1
}

Update rows in a data table

patch

Update rows matching filter conditions in a data table.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Body

returnDatabooleanOptional

If true, return the updated rows; if false, return true on success

Default: false

dryRunbooleanOptional

If true, preview changes without persisting them

Default: false

Responses

200

Rows updated successfully

application/json

booleanOptional

True when returnData is false

400

The request is invalid or provides malformed data.

401

Unauthorized

404

The specified resource was not found.

patch/data-tables/{dataTableId}/rows/update

PATCH /api/v1/data-tables/{dataTableId}/rows/update HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 180

{
  "filter": {
    "type": "and",
    "filters": [
      {
        "columnName": "status",
        "condition": "eq",
        "value": "pending"
      }
    ]
  },
  "data": {
    "status": "completed",
    "updatedBy": "admin"
  },
  "returnData": false,
  "dryRun": false
}

true

Upsert a row in a data table

post

Update an existing row or insert a new one if no row matches the filter conditions.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Body

returnDatabooleanOptional

If true, return the upserted row; if false, return true on success

Default: false

dryRunbooleanOptional

If true, preview changes without persisting them

Default: false

Responses

200

Row upserted successfully

application/json

booleanOptional

True when returnData is false

400

The request is invalid or provides malformed data.

401

Unauthorized

404

The specified resource was not found.

post/data-tables/{dataTableId}/rows/upsert

POST /api/v1/data-tables/{dataTableId}/rows/upsert HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 213

{
  "filter": {
    "type": "and",
    "filters": [
      {
        "columnName": "email",
        "condition": "eq",
        "value": "user@example.com"
      }
    ]
  },
  "data": {
    "email": "user@example.com",
    "name": "Updated Name",
    "status": "active"
  },
  "returnData": true,
  "dryRun": false
}

true

Clear all rows from a data table

delete

Permanently deletes all rows from a data table. The table structure will be retained. This action cannot be undone.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Responses

200

Rows cleared successfully

application/json

deletedCountintegerOptional

The number of rows that were deleted

401

Unauthorized

404

The specified resource was not found.

delete/data-tables/{dataTableId}/rows/clear

DELETE /api/v1/data-tables/{dataTableId}/rows/clear HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Accept: */*

{
  "deletedCount": 1
}

Delete rows from a data table

delete

Delete rows matching filter conditions from a data table. Filter is required to prevent accidental deletion of all data.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Query parameters

filterstring · jsonStringRequired

JSON string of filter conditions. Required to prevent accidental deletion of all data.

Example: {"type":"and","filters":[{"columnName":"status","condition":"eq","value":"archived"}]}

returnDatabooleanOptional

If true, return the deleted rows; if false, return true on success

Default: false

dryRunbooleanOptional

If true, preview which rows would be deleted without actually deleting them

Default: false

Responses

200

Rows deleted successfully

application/json

booleanOptional

True when returnData is false

400

The request is invalid or provides malformed data.

401

Unauthorized

404

The specified resource was not found.

delete/data-tables/{dataTableId}/rows/delete

DELETE /api/v1/data-tables/{dataTableId}/rows/delete?filter=text HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Accept: */*

true

List columns of a data table

get

Retrieve all columns for a specific data table.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Responses

200

Successfully retrieved columns

application/json

idstringRequired

Column ID

namestringRequired

Column name

dataTableIdstringRequired

ID of the data table this column belongs to

typestring · enumRequired

Column data type

Possible values:

indexintegerRequired

Column position

401

Unauthorized

404

The specified resource was not found.

get/data-tables/{dataTableId}/columns

GET /api/v1/data-tables/{dataTableId}/columns HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Accept: */*

[
  {
    "id": "text",
    "name": "text",
    "dataTableId": "text",
    "type": "string",
    "index": 1
  }
]

Add a column to a data table

post

Add a new column to an existing data table.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

Body

namestring · min: 1 · max: 63Required

Column name. Must start with a letter; only letters, digits, and underscores after that; maximum 63 characters.

Pattern: ^[a-zA-Z][a-zA-Z0-9_]*$

typestring · enumRequired

Column data type

Possible values:

indexintegerOptional

Column position (optional, appended to end if omitted)

Responses

201

Column created successfully

application/json

idstringRequired

Column ID

namestringRequired

Column name

dataTableIdstringRequired

ID of the data table this column belongs to

typestring · enumRequired

Column data type

Possible values:

indexintegerRequired

Column position

400

The request is invalid or provides malformed data.

401

Unauthorized

404

The specified resource was not found.

409

Conflict

post/data-tables/{dataTableId}/columns

POST /api/v1/data-tables/{dataTableId}/columns HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 32

{
  "name": "email",
  "type": "string"
}

{
  "id": "text",
  "name": "text",
  "dataTableId": "text",
  "type": "string",
  "index": 1
}

Delete a column

delete

Remove a column from a data table. This will also delete all data in the column.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

columnIdstring · nanoidRequired

The ID of the column

Responses

204

Column deleted successfully

No content

401

Unauthorized

404

The specified resource was not found.

delete/data-tables/{dataTableId}/columns/{columnId}

DELETE /api/v1/data-tables/{dataTableId}/columns/{columnId} HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Accept: */*

No content

Update a column

patch

Rename and/or reorder a column in a data table.

Authorizations

X-N8N-API-KEYstringRequired

Path parameters

dataTableIdstring · nanoidRequired

The ID of the data table

columnIdstring · nanoidRequired

The ID of the column

Body

anyOptional

Responses

200

Column updated successfully

application/json

idstringRequired

Column ID

namestringRequired

Column name

dataTableIdstringRequired

ID of the data table this column belongs to

typestring · enumRequired

Column data type

Possible values:

indexintegerRequired

Column position

400

The request is invalid or provides malformed data.

401

Unauthorized

404

The specified resource was not found.

409

Conflict

patch/data-tables/{dataTableId}/columns/{columnId}

PATCH /api/v1/data-tables/{dataTableId}/columns/{columnId} HTTP/1.1
X-N8N-API-KEY: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 26

{
  "name": "email",
  "index": 1
}

{
  "id": "text",
  "name": "text",
  "dataTableId": "text",
  "type": "string",
  "index": 1
}

PreviousVariables NextProjects

Last updated 5 days ago

Was this helpful?