---
title: "Aggregate the canonical lake over chosen dimensions (spine, entity, period, currency, method, version, grain, fx_state)"
method: POST
path: "/api/v1/query_lake"
---

# Aggregate the canonical lake over chosen dimensions (spine, entity, period, currency, method, version, grain, fx_state)

`POST /api/v1/query_lake`

## Request

- Base URL: `https://k-phi.com` (the document declares no server; this is the origin it was published from)
- URL: `https://k-phi.com/api/v1/query_lake`
- Auth: HTTP bearer

Aggregate the canonical lake over chosen dimensions (spine, entity, period, currency, method, version, grain, fx_state). Returns sums plus a basis verdict. Aggregates ONLY — the lake holds far more lines than belong in a context window, and a sum answers almost every question a row dump would. Undeclared source codes appear as spine="unmapped" and are never folded into a node: if that row is present, the other totals are incomplete and must be reported as such.

## Request body

- object
  - `dims` string: Comma-separated dimensions, e.g. "period,spine". Default "period,spine".

## Response `200`

OK

- object
  - `data` object
  - `meta` object
    - `api` string
    - `capability` string
    - `at` string

## Other responses

- `401`: No or invalid credential
- `403`: Scope, extension or Builder Mode refused
- `422`: The capability refused the input
- `429`: Rate or daily quota reached

---

[API](https://skmtc.dev/k-phi/apis/k-api.md) · [All operations](https://skmtc.dev/k-phi/apis/k-api/llms.txt) · [OpenAPI document](https://skmtc.dev/k-phi/apis/k-api/revisions/60b28690ec35?raw)