CRUD Node

A CRUD (Create, Read, Update, Delete) node performs direct operations on the system database. It allows you to create, query, update, or delete records automatically while a flow is running.

CRUD Actions

Creation (create)

The Create node inserts a new record into the database. It uses the data mapped in the model fields to dynamically generate a new record in the selected entity.

Create Configuration

• Node Name (Required): Unique identification for the node within the flow.
• Reference Category / Type (Required): Select the category that will be the target of the action (e.g., "Contracts").
• Action (Required): Select "Create".
• Model Fields / Mapping (Required): Map the fields that will be automatically filled.

Node Output

The create node will output the data of the created item.

Read an item (readOne)

The Read node retrieves data from a specific record in the database, locating it based on defined parameters.

ReadOne Configuration

• Node Name (Required)
• Type (Required)
• Action (Required): Select "ReadOne".
• Parameters (Required): Map the fields used to locate the item (e.g., ID or SSN).

Node Output

Returns the data of the item located based on the defined parameters.

Read multiple items (readMany)

(Feature coming soon) — Will allow the retrieval of a list of records based on filters for use within the flow.

Update (update)

Modifies an existing record in the database. The flow locates the reference item and updates its fields with the values defined in the mapping.

Update Configuration

• Node Name (Required)
• Type (Required)
• Action (Required): Select "Update".
• Reference item: Select which pre-existing item in the flow will be updated.
• Model Fields (Required): Map the new values for the fields.

Node Output

Returns the data of the item after the update.

Deletion (delete)

Performs a logical deletion of the item. The system does not immediately erase the record permanently; instead, it changes its status to inactive and logs the action date.

• Recovery: The item can be reactivated within 30 days.
• Permanent: After 30 days, the item may be permanently deleted according to system rules.

Delete Configuration

• Node Name, Type, and Action.
• Reference item: Select the item to be removed.

Node Output

• Message: Confirmation of the execution.
• Item Reference: Identification of the removed item.
• Deleted at: Date and time the deletion was performed.

Field Mapping and Nested Variables

For Create and Update actions, the system allows the use of dynamic variables and the handling of complex structures.

Using Variables

To fill fields with data from other nodes, open the Input tab, locate the data, and drag it into the corresponding field. The variable key will be automatically inserted.

Nested Fields (e.g., Address)

Structured fields have internal groupings. You can map them in two ways:

1. Individual Mapping: Drag specific subfields (e.g., just the Zip Code) to fill simple text fields.
2. Grouped Mapping: Drag an entire address variable directly onto the title of an address field in the map. The system will automatically fill all compatible subfields.