table-columns

Preview a column's duplicate rows

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.

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

Path parameters

table_idstring uuid required
column_idstring uuid required

Response

Successful Response

duplicate_row_countinteger required

Rows beyond the first for each repeated value: the full count.

groups_countinteger required

Distinct values that occur in more than one row.

record_idsstring[] required

The deletable rows in display order, capped at the bulk-delete limit.

truncatedboolean required

Whether duplicate_row_count exceeds the returned record IDs.

Changes

No recorded changes to this operation across all 1 revision of this API.