# Data table - Workflow node | Docs - nodulz

Source: https://nodulz.com/docs/nodes/workflow_table

Language: en

JSON rows stored in nodulz, scoped to this workflow (no external database)

## Usage and specifics

These tables persist in nodulz and belong to the workflow. Define columns and types before inserting. Conflict and matching modes control upserts and updates.

Technical type : `workflow_table`. Runtime : `nodulz`.

## Credentials and prerequisites

This node defines no dedicated external credential. Remote sources or execution targets may still need their own access credentials.

See the [credentials guide](/docs/credentials) if a remote source or execution target requires access.

## Parameters

Names below are technical keys. Defaults are not a ready-to-run configuration: complete fields required by your operation. Paths containing [] describe list items; some fields depend on the selected mode.

| Parameter | Type | Default | Values / limits |
| --- | --- | --- | --- |
| `tableScope` | `enum` | `"workspace"` | `workspace`, `legacy` |
| `tableId` | `string` | - | - |
| `operation` | `enum` | `"select"` | `list_tables`, `create_table`, `alter_table`, `drop_table`, `clear_table`, `select`, `insert`, `bulk_insert`, `update`, `delete` |
| `table` | `string` | `"items"` | - |
| `tableNameInputMode` | `enum` | `"select"` | `select`, `text` |
| `schemaColumns` | `string` | `"[]"` | - |
| `seedData` | `string` | `""` | - |
| `columns` | `string` | `"*"` | - |
| `data` | `string` | `""` | - |
| `match` | `string` | `""` | - |
| `orderBy` | `string` | `""` | - |
| `limit` | `string` | `""` | - |
| `insertFieldMode` | `enum` | `"schema_only"` | `schema_only`, `extend_schema` |
| `insertConflictMode` | `enum` | `"fail"` | `fail`, `skip`, `upsert`, `replace` |
| `ifNotExists` | `boolean` | `false` | - |
| `ifExists` | `boolean` | `false` | - |

## Configuration help

| Setting | Purpose and guidance |
| --- | --- |
| `operation`<br>Operation | Create or query an internal table identified by name within this workflow. |
| `insertFieldMode`<br>Inserted fields | Schema columns only (drop extra keys) or extend the table schema from keys found in the data. |
| `insertConflictMode`<br>On constraint conflict | When a row violates a primary key or unique column: fail the operation, skip the row, merge into the existing row (upsert), or delete the existing row then insert (replace). With no PK or unique columns, every row is inserted. |
| `seedData`<br>Seed rows | Rows inserted when the table is created. Values may be workflow expressions. |
| `columns`<br>Columns | Comma-separated column list or * for all columns. |
| `orderBy`<br>ORDER BY | Sort on a row field, e.g. score DESC or created_at ASC. |
| `limit`<br>LIMIT | Maximum number of rows to return (positive integer). |
| `ifNotExists`<br>IF NOT EXISTS | Adds IF NOT EXISTS to the DDL statement. |
| `ifExists`<br>IF EXISTS | Adds IF EXISTS to the DDL statement. |

## Initial configuration

Initial catalog configuration example, to adapt before running. Keep secrets in credentials.

```json
{
  "tableScope": "workspace",
  "operation": "select",
  "table": "items",
  "tableNameInputMode": "select",
  "schemaColumns": "[]",
  "seedData": "",
  "columns": "*",
  "data": "",
  "match": "",
  "orderBy": "",
  "limit": "",
  "insertFieldMode": "schema_only",
  "insertConflictMode": "fail",
  "ifNotExists": false,
  "ifExists": false
}
```

## Verification

Test with representative data. Check node output in the inspector and logs, then use editor mapping for downstream fields. A trigger test with a simulated payload does not validate external service delivery.

See also : [Expressions and data](/docs/expressions), [Executions](/docs/executions), [Node catalog](/docs/nodes).

## Explore further

- [Features - nodulz](https://nodulz.com/product/overview)
- [Node catalog - nodulz](https://nodulz.com/product/catalog)
- [MCP server - nodulz](https://nodulz.com/product/mcp)
- [Pricing - nodulz](https://nodulz.com/pricing)
- [Use cases and workflow automation - nodulz](https://nodulz.com/use-cases)
- [Choose what your workflows can do. - nodulz](https://nodulz.com/compare)
- [Documentation - nodulz](https://nodulz.com/docs)