Delete rows from database table
Delete rows matching the filter conditions. Filter conditions are passed as query parameters using PostgREST syntax.
**Filter Syntax:**
- `?column=eq.value` - Equal
- `?column=neq.value` - Not equal
- `?column=gt.value` - Greater than
- `?column=gte.value` - Greater than or equal
- `?column=lt.value` - Less than
- `?column=lte.value` - Less than or equal
- `?column=like.*pattern*` - LIKE (case-sensitive)
- `?column=ilike.*pattern*` - ILIKE (case-insensitive)
- `?column=in.(a,b,c)` - IN list
- `?column=is.null` - IS NULL
**Safety:** Filters are required by default to prevent accidental bulk deletes. To delete all rows intentionally, pass `?force=true`.
Authentication
X-API-KEYstring
API Key authentication via header
OR
AuthorizationBearer
Bearer authentication of the form Bearer <token>, where token is your auth token.
Path parameters
asset_id
table_name
Query parameters
force
Set to true to delete all rows (required when no filters provided)
Request
This endpoint expects a nullable object.
return_representation
If true, return the deleted rows in the response
Response
Successful Response
data
Affected rows (returned when return_representation=true)
