API Reference

Delete duplicated rows

delete
https://api.gigasheet.com/datasets//deduplicate-rows

Deletes the duplicated rows based on the given columns and sort model

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
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
LoadingLoading…
Response
Click Try It! to start a request and see the response here!

Updated over 2 years ago