---
title: "Create aggregation"
method: POST
path: "/public/v1/objects/{name}/views/{viewId}/aggregations"
tags: ["Object aggregations"]
---

# Create aggregation

`POST /public/v1/objects/{name}/views/{viewId}/aggregations`

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

## Path parameters

- `name` string, required
- `viewId` integer, required

## Request body

- object
  - `columnId` integer, required
  - `operation` 'COUNT_EMPTY' | 'COUNT_FILLED' | 'PERCENT_EMPTY' | 'PERCENT_FILLED' | 'SUM' | 'AVERAGE' | 'MIN' | 'MAX' | 'COUNT_TRUE' | 'COUNT_FALSE' | 'PERCENT_TRUE' | 'PERCENT_FALSE', required
  - `tagId` integer, nullable

## Response `201`

Created aggregation

- object
  - `ok` true, required
  - `data` object, required
    - `id` number, required
    - `view_id` number, required
    - `column_id` number, required
    - `operation` string, required
    - `tag_id` number, nullable
    - `created_at` string, nullable, required
    - `updated_at` string, nullable, required

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `404` — Not Found

---

[API](https://skmtc.net/getfrontline/apis/public-api.md) · [All operations](https://skmtc.net/getfrontline/apis/public-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/getfrontline/public-api/revisions/9d33b6aad674/schema)