---
title: "Return aggregated tabular usage rows"
method: GET
path: "/api/trpc/usageAnalytics.getTable"
tags: ["Usage Analytics"]
---

# Return aggregated tabular usage rows

`GET /api/trpc/usageAnalytics.getTable`

## Request

- Base URL: `https://api.kilocode.ai`
- URL: `https://api.kilocode.ai/api/trpc/usageAnalytics.getTable`
- Auth: HTTP bearer

Returns aggregated tabular usage rows grouped by time bucket and optional dimensions. Use this for the detailed breakdown table and CSV export view.

## Response `200`

Successful tRPC response

- object
  - `result` object, required
    - `data` object, required
      - `rows` object[], required
        - `datetime` string, required
        - `dimensions` object, required
        - `costMicrodollars` number, required
        - `requestCount` number, required
        - `inputTokens` number, required
        - `outputTokens` number, required
        - `cacheWriteTokens` number, required
        - `cacheHitTokens` number, required
        - `errorCount` number, required
      - `effectiveGranularity` 'hour' | 'day' | 'week' | 'month', required

## Other responses

- `400`: Invalid request
- `401`: Authentication required
- `403`: Access denied
- `500`: Unexpected server error

---

[API](https://skmtc.dev/kilocode/apis/kilo-code-api.md) - [All operations](https://skmtc.dev/kilocode/apis/kilo-code-api/llms.txt) - [OpenAPI document](https://skmtc.dev/kilocode/apis/kilo-code-api/revisions/9eac48d444a0?raw)