API Reference

Get Aggregations

post
https://api.gigasheet.com/file//aggregation

Returns ungrouped aggregated values as specified in the grid payload

Path Params
string
required

sheet to filter

Body Params

filtered data request

boolean

API may set true to allow unstable result order for faster performance on large files

FieldTypes
array of strings

if the app work with pivot mode the system should check type of field by ex. int, float, string

FieldTypes
integer
filterModel
object
groupKeys
array
groupKeys
pivotCols
array of objects
pivotCols
boolean
rowGroupCols
array of objects
rowGroupCols
sortModel
array of objects
sortModel
integer
ungroupedAggregations
array of objects
ungroupedAggregations
valueCols
array of objects
valueCols
Responses

Updated over 2 years ago

Language
Credentials
Header
Response 
Click Try It! to start a request and see the response here!
Updated over 2 years ago