---
title: "Preview a column's duplicate rows"
method: GET
path: "/tables/{table_id}/columns/{column_id}/duplicates/"
tags: ["table-columns"]
---

# Preview a column's duplicate rows

`GET /tables/{table_id}/columns/{column_id}/duplicates/`

## Request

- Base URL: `https://api.getoneprofile.ai` (the document declares no server; this is the origin it was published from)
- URL: `https://api.getoneprofile.ai/tables/{table_id}/columns/{column_id}/duplicates/`
- Auth: one of:
  - API key in header `X-API-Key`
  - HTTP bearer

Report which rows a dedupe of this column would delete, without deleting anything. The first row holding each repeated value is kept, in the table's display order; blank cells are never duplicates. The returned record IDs are the losers, ready to hand to the bulk row delete, capped at its own 1000-row limit, though duplicate_row_count carries the full number either way.

## Path parameters

- `table_id` string, uuid, required
- `column_id` string, uuid, required

## Response `200`

Successful Response

- TableColumnDuplicatesResponseSchema: A preview of what deduplicating one column would delete. ``record_ids`` are the rows that would GO, ordered as the grid shows them, which is also the order the keeper rule reads: the first row holding each repeated value survives. The caller deletes them through the ordinary bulk delete, so dedupe inherits its cap and its undo window rather than introducing a second way to remove rows.
  - `duplicate_row_count` integer, required: Rows beyond the first for each repeated value: the full count.
  - `groups_count` integer, required: Distinct values that occur in more than one row.
  - `record_ids` string[], required: The deletable rows in display order, capped at the bulk-delete limit.
  - `truncated` boolean, required: Whether duplicate_row_count exceeds the returned record IDs.

## Other responses

- `401`: Unauthorized
- `403`: Forbidden
- `404`: Table column not found
- `422`: Invalid request made to the API.
- `500`: Internal server error.
- `502`: Bad gateway error.
- `503`: Service unavailable.

---

[API](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile.md) · [All operations](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile/llms.txt) · [OpenAPI document](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile/revisions/4a6bd71e3f02?raw)