Custom Table is a Step (action) in Database. Creates a custom MySQL table with the columns you define in the designer.
Custom Table is a Step (action) in Database. Creates a custom MySQL table with the columns you define in the designer.
When the flow reaches this step, JOrchestrator executes Custom Table against your linked site or an external integration, using the field values you set on General and Design. Downstream steps can read the output payload fields defined for this node.
Custom Table is a action step in the Database group. Action steps run in the middle or end of a flow. They perform work on your CMS, call external services, or transform data for the next step.
Typical reasons teams add Custom Table to a flow:
Only if the table does not already exist — safe to re-run without dropping data.
Common patterns on the canvas:
Table name uses the #__ prefix; column types and keys are set on the Design tab.
The designer shows these tabs for this node:
| Tab | Purpose |
|---|---|
| Info | Plain-language description and output payload fields for downstream steps |
| General | Canvas label and read-only node ID |
| AI | Optional assistant to help draft settings from plain language |
| Design | Node-specific configuration fields |
These fields are managed by the designer or runtime — you do not type into them directly:
| Property key | Label | Type | Required | Visible when | Notes |
|---|---|---|---|---|---|
_nodeId | Node ID | node-id | No | — | — |
_payloadFields | Available Fields | payload-panel | No | — | — |
columns | Columns | table-columns | No | — | — |
| Property key | Label | Type | Required | Visible when | Notes |
|---|---|---|---|---|---|
label | Label | text | No | — | Node label |
| Property key | Label | Type | Required | Visible when | Notes |
|---|---|---|---|---|---|
tableName | Table Name | text | Yes | — | my_custom_table (will be prefixed with #__) |
Credentials, API keys, mailers, SMTP, and integration defaults are configured in the CMS plugin under Node Configuration, not per step on this node. Link the flow to a domain before testing CMS-backed fields.
After this step runs, later nodes can reference these fields using placeholders such as {{custom_table.table}}.
| Field key | Type | Description |
|---|---|---|
table | string | Table name alias (same as tableName for custom tables). |
tableName | string | Database table name used by the node. |
table | string | Table name alias (same as tableName for custom tables). |
sql | string | SQL query that was executed. |
tableName) must be filled before the flow can be saved.Other steps in the same area of the palette:
delete-row) — Databaseinsert-row) — Databaseselect-row) — Databaseupdate-row) — Database