---
title: "Delete duplicated rows"
method: DELETE
path: "/datasets/{handle}/deduplicate-rows"
tags: ["data_cleanup"]
---

# Delete duplicated rows

`DELETE /datasets/{handle}/deduplicate-rows`

Deletes the duplicated rows based on the given columns and sort model

## Path parameters

- `handle` string, required

## Request body

- DeduplicateDeduplicateRowsRequest
  - `FilterModel` object — Filter model to use when deduplicating. Only rows matching this filter will be deduplicated. All other rows will remain.
  - `columns` string[] — List of column ids used for deduplication. Deduplication is performed based on unique tuples of values from the given columns.
  - `sortModel` StructsSortEntry[] — Sorts to use when deduplicating. If not provided, default sheet row order will be used.
    - `colId` string
    - `pivotFieldGroupId` string — if pivot mode is enabled it can be sorted by pivot field group id (the column headers in pivot mode)
    - `sort` string

## Response `200`

OK

- unknown

## Other responses

- `202` — Accepted
- `400` — Bad Request
- `500` — Internal Server Error

---

[API](https://skmtc.net/freshdesk/apis/gigasheet-api.md) · [All operations](https://skmtc.net/freshdesk/apis/gigasheet-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/freshdesk/gigasheet-api/revisions/d1e5cbb24557/schema)