Tool to count how many duplicates will be removed and how many rows remain when deduplicating. Use when you need to preview the impact of a deduplication operation before executing it, or to understand the number of duplicate rows in a dataset based on specific column combinatio…
handleRequiredstringUnique identifier (handle) of the dataset to analyze for duplicates. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f46c012a_194f_47e5_a639_8ad8d290e491').
columnsarrayList of column IDs used for deduplication. Deduplication is performed based on unique tuples of values from the given columns. If not provided, all columns are used for comparison.
sortModelarraySorts to use when deduplicating. If not provided, default sheet row order will be used. This determines which duplicate rows are kept when multiple rows have the same values in the specified columns.
filterModelobjectFilter model to use when deduplicating. Only rows matching this filter will be deduplicated. All other rows will remain. Each key is a column name, and the value defines the filter condition.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
API key connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.