DB Table Row Insert or Modify

Overview

DB Table Row Insert or Modify writes row values into the configured table.

This tool is the main row writer and supports typed values, per-column update operators, image normalization options, optional dashboard update, and sync or async execution.

Input

Variable Source

string required

Reference to a DB Table Initialize node.

The selected setup node provides table identity and column schema metadata.

Column Metadata (Reference)

array

Read-only schema context loaded from the selected setup node.

This drives row editor behavior and ensures each row value maps to the correct column name and data type.

Row Values

array required

Data payload for one row write operation. Each row item is column-oriented and type-aware.

For each column item, relevant fields include:

• valString: string value. Supports Template Expressions.
• valNumber: numeric value.
• valInteger: integer value.
• valBool: boolean value.
• valImage: base64 image or image reference.
• valDateTime: ISO datetime string.
• valRef: reference-based value source when configured by the row widget.
• columnUpdateMode: arithmetic update behavior for numeric columns (SET, ADD, SUBTRACT, MULTIPLY, DIVIDE).
• imageMaxResolution: maximum image edge size before resizing.
• imageQuality: image encoding quality from 0 to 100.

In UI mode, column name and column type are supplied by the table schema and attached to each row item.

Update Dashboard Data

boolean required

When enabled, dashboard data snapshots are refreshed after the write.

Disable this for bulk writes when dashboard refresh is not required.

Wait for Completion

boolean required

Execution mode:

• true: synchronous, downstream nodes run after DB write finishes.
• false: asynchronous, flow continues immediately.

Use sync mode when downstream logic depends on persisted DB state.

Output

Update Dashboard Data

boolean

Echoes whether dashboard update was requested for this operation.