Update Node

U

Data/Database/Update

Set fields on rows matching a filter. With offline buffering enabled, success means durable local acceptance; Write State reports pending cloud replay.

update_local_dbdata

Inputs5

Outputs3

Security exposureUnrated

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

5

Input

Execution

exec_in

Database

Struct

database

Database connection

SchemaNodeDBConnectionNodeDBConnectionNodeDBConnection1 fields

cache_keystringrequired

Schema enforced

SQL Filter

String

filter

Rows to update. Use true to update every row. Values from $name pins are bound as literals.

Params

Struct

params

Values for the filter's $placeholders, as an object keyed by placeholder name without the $ (e.g. {"customer_id": 42}). Only needed when the filter itself comes from a wire — a literal filter derives one pin per placeholder instead. Where both supply the same name, the derived pin wins unless it is empty.

Schemaobjectobjectobject0 fields

No named fields in this schema.

Default {}

Updates

Struct

updates

Object mapping column names to replacement values

Schemaobjectobjectobject0 fields

No named fields in this schema.

Output Pins

3

Success

Execution

exec_out

Accepted by the configured store

Write State

String

write_state

pending means durable on this device and awaiting cloud replay; buffered means process-local batching; applied means the configured store accepted the write

Operation ID

String

operation_id

Durable offline operation ID, or empty when this write has no offline receipt. For chunked imports this is the last accepted chunk.

Node Info

Internal name

update_local_db

Category

Data/Database/Update

Version

1