Gigasheet Count Dataset Rows

Ending row index for pagination (exclusive). Use with startRow to count a specific range of rows.

Unique identifier (handle) of the dataset to count rows from. Format: lowercase letters a-f, numbers, and underscores (e.g., 'a5f49fe7_dde2_45b3_96d9_1338ebf21904').

Starting row index for pagination (0-based). Use with endRow to count a specific range of rows.

Array of group keys for hierarchical grouping. Used to drill down into specific groups when counting.

List of columns to use as pivot columns in pivot mode. These columns become the new column headers in the pivot table.

Enable pivot mode for counting. When true, enables pivot table functionality with grouping and aggregation.

List of sort specifications to apply before counting. Each specification defines a column and sort direction.

List of value columns for aggregation in pivot mode. Defines which columns to aggregate and how.

List of field types (e.g., 'int', 'float', 'string') for type checking in pivot mode. System uses these to validate field types during operations.

Filter model specifying which rows to include in the count. Each key is a column name, and the value defines the filter condition (e.g., {'Status': {'type': 'equals', 'filter': 'Active'}}). See Gigasheet Filter Model documentation for detailed filter syntax.

List of columns to group by when counting rows. Used to create row groupings in pivot mode.

Allow unstable result ordering for better performance on large datasets. When true, the API may return results in a non-deterministic order to optimize query speed.