---
title: "Get Aggregations"
method: POST
path: "/file/{handle}/aggregation"
tags: ["data"]
---

# Get Aggregations

`POST /file/{handle}/aggregation`

Returns ungrouped aggregated values as specified in the grid payload

## Path parameters

- `handle` string, required

## Request body

- StructsRequestAgGrid
  - `AllowUnstableOrder` boolean — API may set true to allow unstable result order for faster performance on large files
  - `FieldTypes` string[] — if the app work with pivot mode the system should check type of field by ex. int, float, string
  - `endRow` integer
  - `filterModel` object
  - `groupKeys` unknown[]
    - unknown
  - `pivotCols` StructsColumnVO[]
    - `aggFunc` string
    - `displayName` string
    - `field` string
    - `groupFunc` string
    - `id` string
  - `pivotMode` boolean
  - `rowGroupCols` StructsColumnVO[]
    - `aggFunc` string
    - `displayName` string
    - `field` string
    - `groupFunc` string
    - `id` string
  - `sortModel` StructsSortEntry[]
    - `colId` string
    - `pivotFieldGroupId` string — if pivot mode is enabled it can be sorted by pivot field group id (the column headers in pivot mode)
    - `sort` string
  - `startRow` integer
  - `ungroupedAggregations` StructsColumnVO[]
    - `aggFunc` string
    - `displayName` string
    - `field` string
    - `groupFunc` string
    - `id` string
  - `valueCols` StructsColumnVO[]
    - `aggFunc` string
    - `displayName` string
    - `field` string
    - `groupFunc` string
    - `id` string

## Response `200`

OK

- unknown

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `403` — Forbidden
- `500` — Internal Server Error
- `503` — Service Unavailable

---

[API](https://skmtc.net/freshdesk/apis/gigasheet-api.md) · [All operations](https://skmtc.net/freshdesk/apis/gigasheet-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/freshdesk/gigasheet-api/versions/d1e5cbb24557/schema)