Skip to main content
GET
Preview a column's duplicate rows

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

table_id
string<uuid>
required
column_id
string<uuid>
required

Response

Successful Response

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<uuid>[]
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.