Jiffy Insert/Update node is used to Insert or update the data in Jiffy Tables. The output of the Jiffy insert/update node is the UUID of the row that has been inserted/updated.

Setting Up Data Fields

Choose either one of the operation (Insert or Update or Bulk Insert) using the dropdown and specify the following fields in the Data tab:

• Actions: Insert / Update / Bulk Insert to be chosen based on the requirement.
• Select table: Table on which (insert/update/Bulk Insert) action to be performed.
• Columns: Columns on which value to inserted / update /bulk update performed.
• Variable: Variable to be used for assigning the value.

Actions

Following options are available in the Actions tab:

Insert

When the Insert option (1) is chosen, a single row is inserted in the selected table. The output is UUID of the row inserted.

• Each column of the table selected is auto listed and the value can be provided for each column. Do either of the following:
  • Provide constant value to insert for the column in the variable placeholder (2).
  • Toggle the button to variable and select the required variable from the dropdown to insert into the column (3).
    Read more about variables here.
• The columns can be deleted using the Delete icon (4).
• New columns can be added using the + icon (5).

Update

When the Update option is chosen, a single row is updated in the selected table and for the UUID that is selected. The output of this node will be the UUID of the row updated.

• To update the columns, do the following:
  • Select the column from the dropdown that lists all the columns of the selected table (6).
  • Provide constant value to be updated for the column in the variable placeholder (7).
  • Toggle the button to variable and select the required variable from the dropdown to update in the column (8).
    Read more about variables here.
• The columns can be deleted using the Delete icon (9).
• New columns can be added using the + icon (10).

Bulk Insert

When the Bulk Insert (11) option is chosen, multiple rows are inserted into the selected table. The Output is a table of UUIDs of the rows inserted.

• To insert the columns, do the following:
  • Select the column from the dropdown that lists all the columns of the selected table.
  • Provide constant value to insert for the column in the variable placeholder (12).
  • Toggle the button to variable and select the required variable from the dropdown to insert into the column (13).
    Read more about variables here.
• The columns can be deleted using the Delete icon (14).
• New columns can be added using the + icon (15).

Variables & Table Definition

Read about Variables and Table Definition to know more.

Properties Of Jiffy Insert Update Node

• Name: Name of the node. A default name is displayed in this field, which the user can edit according to the task and the intent of using the node.
• Description: A short note on the purpose of the node.
• Mark run Failure on Node Fail? : When the Mark run Failure on Node Fail field is ON, if the node execution fails then the complete task execution is marked as fail.
• Continue on no result?: When Continue on no result? field is ON, the task execution continues even when the database query returns no results. When Continue on no result?field is OFF,if the node fails, the execution will not continue to the next node.

Refer to Data Manipulation sample task to know how to use Jiffy Insert/Update node in a task.