Skip to main content
POST
Delete Import Rows
← Imports Remove specific rows from an import session before submission. Use this when rows cannot be corrected and should be excluded from the import. You can delete individual rows by index, remove all error rows at once, or delete every row that Get Import Rows lists for some errors_only and filters. Send exactly one of row_indices, delete_all_errors and match.
Deleted rows are physically removed and cannot be recovered. The row indices of remaining rows are not renumbered.

Request

Headers

string
required
Your API key for authenticationExample: sk_live_1234567890abcdef
string
required
Your organization UUIDExample: a8315ef3-dd50-43f8-b7ce-d839e68d51fa

Path Parameters

string
required
UUID of the import sessionExample: "11111111-1111-1111-1111-111111111111"

Body Parameters

array[integer]
Zero-based indices of rows to delete (max 10,000).
boolean
default:"false"
When true, delete all rows that have validation errors.
object
Delete every row that Get Import Rows lists with these parameters, on every page.Example: {"errors_only": true, "filters": {"client": ["Acme"]}}

Response

integer
Number of rows that were deleted
integer
Total rows remaining after deletion
integer
Valid rows remaining
integer
Error rows remaining (0 if delete_all_errors was used)

Example

Successful Response

Common Errors

400 Bad Request

Cause: The body sets none or more than one of row_indices, delete_all_errors and match
Cause: The rows to delete are every row of the import, for example {"match": {"errors_only": false}}. An import keeps at least one row.
Cause: The import is not validated: rows can only be deleted between validation and submission.

401 Unauthorized

Cause: Missing or invalid API key

403 Forbidden

Cause: The authenticated user is not a member of the organization

404 Not Found

Cause: The import session does not exist or belongs to another organization. Both cases return the same response, so a session id from another organization is indistinguishable from one that does not exist.
Cause: The session’s project is no longer one your organization can import into (for example, the organization was unlinked from it). Every step of the session answers this, not only the submit. Create a new session on a project you work in.

422 Unprocessable Entity

Cause: match has an unknown field or no errors_only, or match.filters breaks a limit: a column key outside [a-zA-Z0-9_()], more than 20 columns or more than 500 values for one column.

Patch Rows

Fix rows instead of deleting them

Get Import Rows

Review rows before deletion

Submit Import

Submit after cleaning up errors