---
title: "GET /rest/users-aggregate"
method: GET
path: "/rest/users-aggregate"
---

# GET /rest/users-aggregate

`GET /rest/users-aggregate`

## Query parameters

- `distinctOn` UsersSelectColumn[]
  - `id` object
  - `name` object
  - `rocket` object
  - `timestamp` object
  - `twitter` object
- `limit` integer
- `offset` integer
- `order_by` UsersOrderBy[]
  - `id` object
  - `name` object
  - `rocket` object
  - `timestamp` object
  - `twitter` object
- `where` UsersBoolExp
  - `_and` object[]
  - `_not` object
  - `_or` object[]
  - `id` object
  - `name` object
  - `rocket` object
  - `timestamp` object
  - `twitter` object
- `usersAggregateAggregateAggregateCountColumns` UsersSelectColumn[]
  - `id` object
  - `name` object
  - `rocket` object
  - `timestamp` object
  - `twitter` object
- `usersAggregateAggregateAggregateCountDistinct` boolean

## Response `200`

- UsersAggregate
  - `aggregate` UsersAggregateFields
    - `count` integer
    - `max` UsersMaxFields
      - `name` string
      - `rocket` string
      - `timestamp` object
      - `twitter` string
    - `min` UsersMinFields
      - `name` string
      - `rocket` string
      - `timestamp` object
      - `twitter` string
  - `nodes` Users[], required
    - `id` object, required
    - `name` string
    - `rocket` string
    - `timestamp` object, required
    - `twitter` string

## Changes

- **2026-07-17** `46a3b0b96b33` — 1 breaking, 1 warning, 1 info
  - for the `query` request parameter `usersAggregateAggregateAggregateCountColumns`, the type/format of property `items/` was specialized from ``/`` to `object`/``
  - deleted the `query` request parameter `distinct_on`
  - added the new optional `query` request parameter `distinctOn`
- **2019-10-22** `56b431e70bf6` — 1 info
  - endpoint added
- **2019-01-17** `0ce2fdacbf21` — 1 breaking
  - api path removed without deprecation

[Change history](https://skmtc.dev/spacexland/apis/spacex-rest-api/changes/rest/users-aggregate/get.md)

---

[API](https://skmtc.dev/spacexland/apis/spacex-rest-api.md) · [All operations](https://skmtc.dev/spacexland/apis/spacex-rest-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/spacexland/spacex-rest-api/revisions/46a3b0b96b33/schema)