ssjs.guide SFMC

DeleteData

→ number

Removes rows from a Data Extension matching the specified filter criteria. Returns the number of rows deleted.

Available in: Email CloudPage Automation Triggered Send

Syntax

Platform.Function.DeleteData(deName, filterField, filterValue [, filterField2, filterValue2, ...])
3+ arguments

Parameters

Name Type Required Description
deName string Yes Data Extension name or external key
filterField string Yes Column name to filter on
filterValue string Yes Value to match for deletion
filterField2 string No Additional filter column (AND)
filterValue2 string No Additional filter value

Examples

Basic delete

var deleted = Platform.Function.DeleteData(
    "TempSessions",
    "SessionToken", token
);
Write("Deleted " + deleted + " session(s).");

Multi-filter delete

// Delete expired AND inactive records
Platform.Function.DeleteData(
    "TempData",
    "Status",     "expired",
    "Active",     "0"
);

Safe delete pattern

// Verify the record exists before deleting
var exists = Platform.Function.Lookup("Orders", "OrderID", "OrderID", orderId);
if (exists) {
    var count = Platform.Function.DeleteData("Orders", "OrderID", orderId);
    Write("Deleted " + count + " order(s).");
} else {
    Write("Order not found.");
}

Notes

  • Returns 0 when no rows match (not an error)
  • DeleteDE is an alias with identical behavior
  • Irreversible — SFMC DEs have no built-in undo. Always verify the filter before deleting.

See Also

See Also