--- title: "Clickhouse Customers Retrieve" method: GET path: "/clickhouse/customers/{unique_organization_id}/" tags: ["users"] --- # Clickhouse Customers Retrieve `GET /clickhouse/customers/{unique_organization_id}/` Retrieve a single organization (customer) by ID. Supports both JWT and API key authentication. Requires superadmin access (is_superadmin=True). ## Path parameters - `unique_organization_id` string, required ## Headers - `Authorization` string, required ## Response `200` - CHCustomerDetail - `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 - `organization_subscription` CHOrganizationSubscriptionCustomerPage, required - `id` integer, required - `api_key_count` integer, required - `plan_level` integer, required - `api_key_limit` integer, required - `log_limit` integer, required - `current_customer_id` string, required - `dataset_size_limit` integer, required - `credits` Credit[], required - `id` integer, required - `expired` boolean, required - `amount` number, double - `currency` string - `description` string - `created_at` string, date-time, required - `expire_at` string, date-time, nullable - `recurring` boolean - `hidden_threshold` number, double - `organization_subscription` integer, nullable - `active_billing` boolean, required - `seats_cost_for_full_period` number, double, required - `prompts_cost` number, double, required - `free_trial_days_left` integer, required - `current_period_start_dt` string, date-time, required - `current_period_end_dt` string, date-time, required - `is_on_free_trial` boolean, required - `plan` string, required - `mrr` number, double, required - `invoice_this_period` number, double, required - `invoice_last_period` number, double, required - `free_log_limit` integer, required - `logs_cost_this_period` number, double, required - `logs_cost_last_period` number, double, required - `member_limit` integer, required - `member_count` integer, required - `monthly_seats_cost` number, double, required - `current_usage_period_start_dt` string, date-time, required - `current_usage_period_end_dt` string, date-time, required - `prompt_limit` integer, nullable, required - `evaluator_limit` integer, nullable, required - `dataset_count_limit` integer, nullable, required - `score_limit` integer, nullable, required - `plan_retention_period_in_days` integer, nullable, required - `logs_in_period` integer, required - `logs_three_months_ago` integer, required - `keywordsai_llm_credentials_usage_in_period` number, double, required - `keywordsai_llm_credentials_usage_last_period` number, double, required - `total_cost_with_keywordsai_credentials` number, double, required - `subscription_unique_id` string, nullable - `created_at` string, date-time, nullable, required - `subscribed_at` string, date-time, nullable - `free_trial_end_at` string, date-time, nullable - `log_visibility_cutoff_at` string, date-time, nullable, required - `deal_id` string - `monthly_recurring_revenue` number, double - `expected_annual_contract_value` number, double - `customer_ids` string[] - `metered_item_id` string, nullable - `seat_based_item_id` string, nullable - `base_item_id` string, nullable - `stripe_customer_id` string - `usage_report_subscription_id` string - `subscription_id` string - `current_period_start` number, double - `current_period_end` number, double - `current_usage_period_start` number, double - `current_usage_period_end` number, double - `usage_in_period` number, double - `logs_in_last_period` integer - `customer_user_count` integer - `prompt_count` integer - `evals_in_period` integer - `evals_in_last_period` integer - `past_billing_periods` unknown[] - unknown - `last_usage_reported` number, double - `last_reconciled_at` number, double, nullable - `billing_method` 'stripe' | 'invoice' | 'other' — * `stripe` - Stripe * `invoice` - Invoice * `other` - Other - `billing_period` 'monthly' | 'yearly' — * `monthly` - Monthly * `yearly` - Yearly - `usage_report_interval` 'monthly' | 'yearly' — * `monthly` - Monthly * `yearly` - Yearly - `current_period_invoice_amount` number, double - `last_period_invoice_amount` number, double - `budget` number, double, nullable - `credit_balance` number, double — Current available Keywords AI credit balance in USD - `custom_log_limit` integer, nullable - `custom_plan_name` string - `custom_monthly_cost` number, double, nullable - `custom_yearly_cost` number, double, nullable - `deprecated_subscription_ids` unknown - `subscription_bool` boolean - `custom_subscription` unknown - `custom_bundle` unknown - `accumulative_balance` number, double - `periodic_invoice_amount` number, double - `org` integer, nullable - `project` string, nullable - `company_organization` integer, nullable - `billing_subscription` integer, nullable — If set, credits and billing are managed by this subscription (company-level billing). NULL means this subscription manages its own billing (is a primary billing subscription). - `organization` integer, nullable - `members` OrganizationUserRole[], required - `id` integer, required - `access_level` integer, required - `user` UserRole, required - `id` integer, required - `email` string, required - `name` string, required - `username` string - `first_name` string - `last_name` string - `profile_color` string - `has_customized_password` boolean, required - `organization_name` string, required - `user_count` integer, required - `email` string - `role` 'member' | 'admin' | 'owner' | 'keywordsai_admin' | 'annotator' — * `member` - member * `admin` - admin * `owner` - owner * `keywordsai_admin` - keywordsai_admin * `annotator` - annotator - `pending` boolean - `hidden` boolean - `permissions_override` string[], nullable - `organization` integer, required - `project` string, nullable - `total_member_count` integer, required - `has_provider_keys` boolean, required - `sibling_organizations` OrganizationList[], required - `id` string, required - `unique_organization_id` string - `name` string, required - `logo` string, uri, nullable - `has_api_keys` boolean, required - `status` string, nullable, required - `onboarded` boolean, required - `has_api_call_with_non_default_key` boolean, required - `onboarding_method` string, nullable, required - `gateway_onboarding_completed_at` string, nullable, required - `tracing_onboarding_completed_at` string, nullable, required - `onboarding_integration_options` object, required - `fallback_model_enabled` boolean, required - `fallback_models` string[], required - `system_fallback_enabled` boolean, required - `retry_enabled` boolean, required - `num_retries` integer, required - `total_logging_cost` number, double, required --- [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)