Look up and delete multiple existing records as a single operation. This Workflow Studio step removes the need to first look up a list of records and then delete each record in the list.

Roles and availability

Available as an Workflow Studio action step. Users with the action_designer role can create a custom action with one or more action steps.

Fields

FieldDescription
Table Select the table containing the records to delete.
Conditions Define the filter condition used to look up records.
Order by Select the field that you want to use to sort the records when more than one record matches the defined conditions.
Sort Type Determine whether to sort the records alphabetically in ascending or descending order.
Run Business Rules and Workflow Determine whether to call any business rules and workflows associated with the table.
Don't fail on error Specify whether to continue running the flow when there is an error.

Action error evaluation

If this step fails
Data type: Choice

Option to continue running the next step or go to error evaluation. To use the step status code or message for a custom action error condition, see Action error evaluation.

Example

Example Delete Multiple Records step.
Note: The example is for illustration purposes only.

Outputs

Field Description Data Type
Count Number of records deleted. If no records are deleted, the count is 0. Integer
Error Message Message that is displayed if the step produces an error. String
Status The completion status of the step as a numeric value.
  • 0 (success)
  • 1 (error)
 Choice