n8n Public API — DataTable

naftiko: 1.0.0-alpha2
info:
  label: n8n Public API — DataTable
  description: 'n8n Public API — DataTable. 13 operations. Lead operation: List all data tables. Self-contained Naftiko capability
    covering one N8n business surface.'
  tags:
  - N8n
  - DataTable
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    N8N_API_KEY: N8N_API_KEY
capability:
  consumes:
  - type: http
    namespace: n8n-datatable
    baseUri: https://app.n8n.cloud/api/v1
    description: n8n Public API — DataTable business capability. Self-contained, no shared references.
    resources:
    - name: data-tables
      path: /data-tables
      operations:
      - name: listdatatables
        method: GET
        description: List all data tables
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: createdatatable
        method: POST
        description: Create a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: data-tables-dataTableId
      path: /data-tables/{dataTableId}
      operations:
      - name: getdatatable
        method: GET
        description: Get a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
      - name: deletedatatable
        method: DELETE
        description: Delete a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
      - name: updatedatatable
        method: PATCH
        description: Update a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
    - name: data-tables-dataTableId-columns
      path: /data-tables/{dataTableId}/columns
      operations:
      - name: listdatatablecolumns
        method: GET
        description: List columns in a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
      - name: adddatatablecolumn
        method: POST
        description: Add a column to a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
    - name: data-tables-dataTableId-columns-columnId
      path: /data-tables/{dataTableId}/columns/{columnId}
      operations:
      - name: deletedatatablecolumn
        method: DELETE
        description: Delete a column from a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
        - name: columnId
          in: path
          type: string
          required: true
    - name: data-tables-dataTableId-rows
      path: /data-tables/{dataTableId}/rows
      operations:
      - name: listdatatablerows
        method: GET
        description: List rows in a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
      - name: insertdatatablerows
        method: POST
        description: Insert rows into a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
    - name: data-tables-dataTableId-rows-delete
      path: /data-tables/{dataTableId}/rows/delete
      operations:
      - name: deletedatatablerows
        method: POST
        description: Delete rows in a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
    - name: data-tables-dataTableId-rows-update
      path: /data-tables/{dataTableId}/rows/update
      operations:
      - name: updatedatatablerows
        method: POST
        description: Update rows in a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
    - name: data-tables-dataTableId-rows-upsert
      path: /data-tables/{dataTableId}/rows/upsert
      operations:
      - name: upsertdatatablerows
        method: POST
        description: Upsert rows in a data table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: dataTableId
          in: path
          type: string
          required: true
    authentication:
      type: bearer
      token: '{{env.N8N_API_KEY}}'
  exposes:
  - type: rest
    namespace: n8n-datatable-rest
    port: 8080
    description: REST adapter for n8n Public API — DataTable. One Spectral-compliant resource per consumed operation, prefixed
      with /v1.
    resources:
    - path: /v1/data-tables
      name: data-tables
      description: REST surface for data-tables.
      operations:
      - method: GET
        name: listdatatables
        description: List all data tables
        call: n8n-datatable.listdatatables
        outputParameters:
        - type: object
          mapping: $.
      - method: POST
        name: createdatatable
        description: Create a data table
        call: n8n-datatable.createdatatable
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/data-tables/{datatableid}
      name: data-tables-datatableid
      description: REST surface for data-tables-dataTableId.
      operations:
      - method: GET
        name: getdatatable
        description: Get a data table
        call: n8n-datatable.getdatatable
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
      - method: DELETE
        name: deletedatatable
        description: Delete a data table
        call: n8n-datatable.deletedatatable
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
      - method: PATCH
        name: updatedatatable
        description: Update a data table
        call: n8n-datatable.updatedatatable
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/data-tables/{datatableid}/columns
      name: data-tables-datatableid-columns
      description: REST surface for data-tables-dataTableId-columns.
      operations:
      - method: GET
        name: listdatatablecolumns
        description: List columns in a data table
        call: n8n-datatable.listdatatablecolumns
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
      - method: POST
        name: adddatatablecolumn
        description: Add a column to a data table
        call: n8n-datatable.adddatatablecolumn
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/data-tables/{datatableid}/columns/{columnid}
      name: data-tables-datatableid-columns-columnid
      description: REST surface for data-tables-dataTableId-columns-columnId.
      operations:
      - method: DELETE
        name: deletedatatablecolumn
        description: Delete a column from a data table
        call: n8n-datatable.deletedatatablecolumn
        with:
          dataTableId: rest.dataTableId
          columnId: rest.columnId
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/data-tables/{datatableid}/rows
      name: data-tables-datatableid-rows
      description: REST surface for data-tables-dataTableId-rows.
      operations:
      - method: GET
        name: listdatatablerows
        description: List rows in a data table
        call: n8n-datatable.listdatatablerows
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
      - method: POST
        name: insertdatatablerows
        description: Insert rows into a data table
        call: n8n-datatable.insertdatatablerows
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/data-tables/{datatableid}/rows/delete
      name: data-tables-datatableid-rows-delete
      description: REST surface for data-tables-dataTableId-rows-delete.
      operations:
      - method: POST
        name: deletedatatablerows
        description: Delete rows in a data table
        call: n8n-datatable.deletedatatablerows
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/data-tables/{datatableid}/rows/update
      name: data-tables-datatableid-rows-update
      description: REST surface for data-tables-dataTableId-rows-update.
      operations:
      - method: POST
        name: updatedatatablerows
        description: Update rows in a data table
        call: n8n-datatable.updatedatatablerows
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/data-tables/{datatableid}/rows/upsert
      name: data-tables-datatableid-rows-upsert
      description: REST surface for data-tables-dataTableId-rows-upsert.
      operations:
      - method: POST
        name: upsertdatatablerows
        description: Upsert rows in a data table
        call: n8n-datatable.upsertdatatablerows
        with:
          dataTableId: rest.dataTableId
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: n8n-datatable-mcp
    port: 9090
    transport: http
    description: MCP adapter for n8n Public API — DataTable. One tool per consumed operation, routed inline through this capability's
      consumes block.
    tools:
    - name: list-all-data-tables
      description: List all data tables
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: n8n-datatable.listdatatables
      outputParameters:
      - type: object
        mapping: $.
    - name: create-data-table
      description: Create a data table
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: n8n-datatable.createdatatable
      outputParameters:
      - type: object
        mapping: $.
    - name: get-data-table
      description: Get a data table
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: n8n-datatable.getdatatable
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.
    - name: delete-data-table
      description: Delete a data table
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: n8n-datatable.deletedatatable
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.
    - name: update-data-table
      description: Update a data table
      hints:
        readOnly: false
        destructive: false
        idempotent: true
      call: n8n-datatable.updatedatatable
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.
    - name: list-columns-data-table
      description: List columns in a data table
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: n8n-datatable.listdatatablecolumns
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.
    - name: add-column-data-table
      description: Add a column to a data table
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: n8n-datatable.adddatatablecolumn
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.
    - name: delete-column-data-table
      description: Delete a column from a data table
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: n8n-datatable.deletedatatablecolumn
      with:
        dataTableId: tools.dataTableId
        columnId: tools.columnId
      outputParameters:
      - type: object
        mapping: $.
    - name: list-rows-data-table
      description: List rows in a data table
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: n8n-datatable.listdatatablerows
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.
    - name: insert-rows-data-table
      description: Insert rows into a data table
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: n8n-datatable.insertdatatablerows
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.
    - name: delete-rows-data-table
      description: Delete rows in a data table
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: n8n-datatable.deletedatatablerows
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.
    - name: update-rows-data-table
      description: Update rows in a data table
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: n8n-datatable.updatedatatablerows
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.
    - name: upsert-rows-data-table
      description: Upsert rows in a data table
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: n8n-datatable.upsertdatatablerows
      with:
        dataTableId: tools.dataTableId
      outputParameters:
      - type: object
        mapping: $.