API Reference

Count duplicated rows

post
https://api.gigasheet.com/datasets//deduplicate-rows-count

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

Path Params
string
required

Unique file ID

Body Params

Deduplicate rows request

FilterModel
object

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

columns
array of strings

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

columns
sortModel
array of objects

Sorts to use when deduplicating. If not provided, default sheet row order will be used.

sortModel
Responses

Updated over 2 years ago

Language
Credentials
Header
Response 
Click Try It! to start a request and see the response here! Or choose an example:
application/json
Updated over 2 years ago