data_cleanup

Count duplicated rows

Counts how many duplicates will be removed and how many rows remain when deduplicating

post/datasets/{handle}/deduplicate-rows-count

Request

Base URL
//api.gigasheet.com (relative, and the document’s source URL is not known)
Auth
API key in header X-GIGASHEET-TOKEN
TypeScript
https://skmtc.dev/freshdesk/apis/gigasheet-api/docs/datasets/:handle/deduplicate-rows-count/post.ts
A function with typed inputs. Its response is checked against the schema.

handlestring required

Unique file ID

FilterModelobject

Filter model to use when deduplicating. Only rows matching this filter will be deduplicated. All other rows will remain.

columnsstring[]

List of column ids used for deduplication. Deduplication is performed based on unique tuples of values from the given columns.

Messagestring

Successboolean

deletedRowsCountinteger

remainingRowsCountinteger

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