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。
無料 Action
この Action を明示的に参照する公開 Skills はまだありません。