Gigasheet Count Dataset Rows

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

  Required
  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').
• startRowinteger
  Starting row index for pagination (0-based). Use with endRow to count a specific range of rows.
• groupKeysarray
  Array of group keys for hierarchical grouping. Used to drill down into specific groups when counting.
• pivotColsarray
  List of columns to use as pivot columns in pivot mode. These columns become the new column headers in the pivot table.
• pivotModeboolean
  Enable pivot mode for counting. When true, enables pivot table functionality with grouping and aggregation.
• sortModelarray
  List of sort specifications to apply before counting. Each specification defines a column and sort direction.
• valueColsarray
  List of value columns for aggregation in pivot mode. Defines which columns to aggregate and how.
• FieldTypesarray
  List of field types (e.g., 'int', 'float', 'string') for type checking in pivot mode. System uses these to validate field types during operations.
• filterModelobject
  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.
• rowGroupColsarray
  List of columns to group by when counting rows. Used to create row groupings in pivot mode.
• AllowUnstableOrderboolean
  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.

• data

  Required
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  Required
  Whether or not the action execution was successful or not

No verified related use cases are linked yet.

No published Skills explicitly reference this Action yet.