Aident Loadout を通じて Gigasheet Tools の Gigasheet Create File Aggregation を使用します。実行前に入力、出力、設定、料金、リスクを確認できます。
Tool to retrieve ungrouped aggregated values for a Gigasheet file. Returns aggregated data as specified in the request payload, including support for pivot mode, filtering, sorting, and various aggregation functions. Use when you need to compute summary statistics across columns…
endRowintegerEnding row index for pagination.
handle必須stringUnique identifier (handle) of the file/sheet to aggregate. Typically returned by upload or dataset operations.
startRowintegerStarting row index for pagination.
groupKeysarrayList of group keys to filter by. Empty list means no filtering by group keys.
pivotColsarrayList of column configurations to use for pivoting, if pivot mode is enabled.
pivotModebooleanWhether to enable pivot mode for the aggregation operation.
sortModelarraySort configuration for the aggregation results.
valueColsarrayList of value columns to aggregate.
FieldTypesarrayList of field types if working with pivot mode. System checks type of field by example: int, float, string.
filterModelobjectFilter conditions to apply before aggregation. Keys are column names, values are filter specifications.
rowGroupColsarrayList of column configurations to use for row grouping.
AllowUnstableOrderbooleanSet to true to allow unstable result order for faster performance on large files.
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 はまだありません。