Find Or Insert

Introduction

The "Find or Insert" step retrieves a single entry from a specified table or inserts a new one if no matching entry is found. This step ensures that a specific record always exists in the database.

Configuration

• Table: Specifies the table to search or insert the entry into. This parameter is required.

• Value: Defines the values for the columns of the entry. These values are used to find an existing entry or create a new one. This parameter is required.

Subpaths

• Filter: Provides access to the columns of the specified table. These can be used to define the structure of the value or add conditions.

Outputs

• Value: The retrieved or newly created entry, represented as a row object containing values for all columns in the table.