Bulk Create Rows

The Bulk Create Rows step allows you to create multiple rows in a table.

Send data as an array of objects

By default, the expected format is an array of objects representing the rows to be created. The object keys are the column names and the values are the values to be inserted.

{
  name: "John",
  age: 30
},
{
  name: "Doe",
  age: 28
}

This object will be sent to the server and converted to an INSERT statement like this:

INSERT INTO users (name, age) VALUES ('John', 30), ('Doe', 28);

Note: you can check the Payload section to see the objects sent to the server.

Note: the unset fields will be presented as undefined and will not be used in the INSERT statement, so that the table defaults will be applied

{
  id: 23,
  created_at: "2022-10-21",
  // this value will not be sent to the server
  required_at: undefined,
}

You can always adjust the data before sending it.

To add dynamic data to the query, you can use the table's variables {{ui.table.value}}.