Upsert
Creates or updates a record in a database table.
Inputs
Table
The table that contains the record to be created or updated.
Fields
The fields to create as part of a new record or update as part of an existing record.
Source Field
The value of the field.
Target Value
The field to update.
Key
If enabled, FL0 uses the field to identify if the record already exists. This option is usually enabled for the record's id
field.
Outputs
Data
An array of objects representing each database record that was updated or inserted.
Rows Affected
The number of database records affected by the upsert operation.
Updated 8 months ago