---
title: "Clickhouse Customers List Create"
method: POST
path: "/clickhouse/customers/list/"
tags: ["users"]
---

# Clickhouse Customers List Create

`POST /clickhouse/customers/list/`

List customers with complex filtering via POST body.

## Query parameters

- `page` integer
- `page_size` integer

## Headers

- `Authorization` string, required

## Request body

- CHCustomerFilterRequestRequest — Request body for the customers POST-for-filtering endpoint.
  - `filters` object — Filter parameters keyed by metric name.

## Response `200`

- PaginatedCHCustomerListList
  - `count` integer, required
  - `next` string, uri, nullable
  - `previous` string, uri, nullable
  - `total_count` integer
  - `current_filters` FilterParamDictPydantic — Pydantic model for FilterParamDict. A dictionary that maps metric names to their filter parameters. Each key is a metric name (str), and each value can be: - A single MetricFilterParamPydantic (one condition) - A List[MetricFilterParamPydantic] (multiple conditions for same metric) - A FilterBundlePydantic (nested filter bundle with connector) Note: Uses extra="allow" for dynamic metric name fields. The __pydantic_extra__ annotation tells Pydantic what types to expect for extra fields, and generates typed additionalProperties in JSON Schema.
  - `filters_data` PaginatedChCustomerListListFiltersData
  - `results` CHCustomerList[], required
    - `id` string, required
    - `organization_id` string, required
    - `unique_organization_id` string
    - `owner_email` string
    - `organization_name` string
    - `stripe_customer_identifier` string
    - `user_count` integer
    - `plan` string
    - `is_blocked` boolean
    - `disable_log` boolean
    - `first_seen` string, required
    - `starred` boolean
    - `last_active` string, required
    - `total_tokens` integer, required
    - `total_requests` integer, required
    - `total_cost` number, double, required
    - `active_days` integer
    - `credit_balance` number, double, nullable

---

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