通过 Aident Loadout 使用 Gigasheet Tools 的 Gigasheet Count Dataset Rows。执行前查看输入、输出、设置、价格和风险。
Counts rows in a Gigasheet dataset matching specified filter criteria. Returns the number of rows matching the provided filters, groupings, and other parameters. For basic row counting, only the handle and optionally filterModel need to be specified. Advanced features like pivot…
endRowintegerEnding row index for pagination (exclusive). Use with startRow to count a specific range of rows.
handle必填stringUnique identifier (handle) of the dataset to count rows from. Format: lowercase letters a-f, numbers, and underscores (e.g., 'a5f49fe7_dde2_45b3_96d9_1338ebf21904').
startRowintegerStarting row index for pagination (0-based). Use with endRow to count a specific range of rows.
groupKeysarrayArray of group keys for hierarchical grouping. Used to drill down into specific groups when counting.
pivotColsarrayList of columns to use as pivot columns in pivot mode. These columns become the new column headers in the pivot table.
pivotModebooleanEnable pivot mode for counting. When true, enables pivot table functionality with grouping and aggregation.
sortModelarrayList of sort specifications to apply before counting. Each specification defines a column and sort direction.
valueColsarrayList of value columns for aggregation in pivot mode. Defines which columns to aggregate and how.
FieldTypesarrayList of field types (e.g., 'int', 'float', 'string') for type checking in pivot mode. System uses these to validate field types during operations.
filterModelobjectFilter 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.
rowGroupColsarrayList of columns to group by when counting rows. Used to create row groupings in pivot mode.
AllowUnstableOrderbooleanAllow 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必填Data from the action execution
errorstringError if any occurred during the execution of the action
successful必填booleanWhether or not the action execution was successful or not
API 密钥连接。风险等级 2/5。
免费操作
目前没有已发布技能明确引用此操作。