---
title: "Get one table's per-column credit usage"
method: GET
path: "/credits/usage/by_table/{table_id}/by_column/"
tags: ["credits"]
---

# Get one table's per-column credit usage

`GET /credits/usage/by_table/{table_id}/by_column/`

## Request

- Base URL: `https://api.getoneprofile.ai` (the document declares no server; this is the origin it was published from)
- URL: `https://api.getoneprofile.ai/credits/usage/by_table/{table_id}/by_column/`
- Auth: one of:
  - API key in header `X-API-Key`
  - HTTP bearer

Get one table's per-column usage.

## Path parameters

- `table_id` string, uuid, required

## Query parameters

- `start_time` string, date-time, required: Range start (ISO 8601)
- `end_time` string, date-time, required: Range end (ISO 8601)

## Response `200`

Successful Response

- CreditTableUsageByColumnResponseSchema: Per-column credit usage for one table.
  - `columns` CreditColumnUsageSchema[], required: Sorted by credits descending.
    - `avg_cost_per_cell` number, nullable, required: credits / cells, in decimal credits; null at zero cells.
    - `cell_count` integer, required
    - `column_id` string, uuid, nullable, required
    - `credits_refunded` number, required: Refunded portion, reported separately, in decimal credits.
    - `credits_spent` number, required: Net of any refunds attributed to this column, in decimal credits.
    - `name` string, required: Resolved column name; 'Deleted column' when unresolvable.
  - `total_credits_refunded` number, required: In decimal credits.
  - `total_credits_spent` number, required: In decimal credits.

## Other responses

- `401`: Unauthorized
- `403`: Forbidden
- `404`: Table not found
- `422`: Invalid request made to the API.
- `500`: Internal server error.
- `502`: Bad gateway error.
- `503`: Service unavailable.

---

[API](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile.md) · [All operations](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile/llms.txt) · [OpenAPI document](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile/revisions/4a6bd71e3f02?raw)