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.