Bulk Delete Rows

The Bulk Delete Rows step allows you to delete multiple rows in a table by a given condition.

You need to specify the column/columns to find the rows to delete and configure the condition(-s). In case of multiple conditions, the rows will be deleted if all conditions are met.

The condition(s) you specify will be sent to the server and converted to a DELETE statement, for example:

DELETE FROM users WHERE id IN (23, 24, 25);

You can check the action's Payload tab to see the actual conditions sent to the server.

Filters with empty values are omitted from the generated WHERE clause. This includes an empty array used with IN.

If some filters are omitted, the action can delete more rows than intended. If all filters are omitted, it can delete every row in the table.

Add a Condition step before Bulk Delete Rows and run the deletion only when all required filter values are present.