Sign in

v1

latestOpenAPI 3.0.0Proprietary2026-08-062711471.0 MB
Table aggregations

Create aggregation

Creates an aggregation on a column for the given view. Requires a USER API key.

post/public/v1/tables/{name}/views/{viewId}/aggregations

Path parameters

namestring required
Example:tasks_board
viewIdinteger required
Example:11

Request body

columnIdinteger required
operation'COUNT_EMPTY' | 'COUNT_FILLED' | 'PERCENT_EMPTY' | 'PERCENT_FILLED' | 'SUM' | 'AVERAGE' | 'MIN' | 'MAX' | 'COUNT_TRUE' | 'COUNT_FALSE' | 'PERCENT_TRUE' | 'PERCENT_FALSE' required
tagIdinteger nullable

Example request

{
  "columnId": 1,
  "operation": "COUNT_EMPTY",
  "tagId": 1
}

Response

Created aggregation

oktrue required

Example response

{
  "ok": true,
  "data": {
    "id": 1,
    "view_id": 1,
    "column_id": 1,
    "operation": "example",
    "tag_id": 1,
    "created_at": "example",
    "updated_at": "example"
  }
}