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.
handleRequiredstringUnique 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.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
API key connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.