Insert rows

Use Insert rows to create new rows in a table from an API Endpoint workflow.

This is commonly used for endpoints like “create order”, “create user profile”, or “add item to cart”.

Add the action

1. In Data & API, open your API Endpoint workflow.
2. Click + Add an action.
3. Go to Data → Tables.
4. Select Insert rows.

Configuration

Choose a table

Table: Select where the new rows should be created.

Choose an insert mode

You can insert:

• Single: Create one row using a form-like mapping
• Multiple: Create many rows at once from a list

Map your data

Single

In the Data section:

• Use Columns to choose which columns you want to set
• Fill in each column value (you can bind values from inputs, variables, or earlier actions)

Multiple

When using Multiple:

1. Provide the list of items in Data
2. In Mapping, choose which Columns you want to fill
3. For each column, bind the value you want to use for each item in the list

Options

• Return Inserted Data: When enabled, the action returns the newly created rows in the result
• Upsert Mode: When enabled, WeWeb will insert or update if there’s a conflict (useful when you don’t want duplicates)

Result

If Return Inserted Data is enabled, you can use the inserted rows from the action’s result in later steps (for example in a Send response).

CONTINUE LEARNING

Learn how to validate inputs and handle errors cleanly.

Try/Catch →