通过 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。
免费操作
目前没有已发布技能明确引用此操作。