Batch Upsert Node

B

Data/Database/Insert

Inserts if the Item does not exist, Updates if it does

batch_upsert_local_dbdata

Inputs4

Outputs5

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

4

Input

Execution

exec_in

Database

Struct

database

Database Connection Reference

SchemaNodeDBConnectionNodeDBConnectionNodeDBConnection1 fields

cache_keystringrequired

Schema enforced

ID Column

String

id_row

The ID Column

Value

Struct Array

value

Value to Insert

Schemaobjectobjectobject0 fields

No named fields in this schema.

Output Pins

5

Success

Execution

exec_out

Upsert succeeded

Error

Execution

error

Upsert failed

Error Message

String

error_message

Error details

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

batch_upsert_local_db

Category

Data/Database/Insert

Version

3