The request
Reference for Read table, HeadHoncho API v1. It is a read, sent to the base address https://api.headhoncho.app.
GET /api/v1/data/tables/{key}
The key or app needs the Raw data area at read. It counts as a read call: 300 a minute for each key or connected app. See rate limits.
Send your key as Authorization: Bearer hh_live_.... See API keys.
Parameters
| Name | Kind | Required | Description | Example |
|---|---|---|---|---|
key | text, in the path | Yes | A table key from List tables. | google_ads.spend_by_day |
company_id | id, in the query | No | Default: the first company the credential reaches. | cmp_14f5 |
from | date, in the query | No | For tables with a date column. Default: this month. | 2026-10-01 |
to | date, in the query | No | The last day, inclusive. | 2026-10-14 |
order | text, in the query | No | A column key. Default: the table's own order. | date |
direction | text, in the query | No | asc or desc. One of asc, desc. | desc |
limit | number, in the query | No | 1 to 1000. Default 200. | 200 |
offset | number, in the query | No | Rows to skip. Default 0. | 0 |
What comes back
table (its definition), rows, total, limit, offset, and the caveat the screen prints beside this table, because a row that leaves without its sentence will be misread.
It never changes a record. It only reads the companies the key reaches.
Errors that apply
| Code | Status | What it means |
|---|---|---|
| `missing_key` | 401 | Send your key as Authorization: Bearer hh_live_... |
| `unknown_key` | 401 | That key is not one we issued, or it was revoked. |
| `expired_token` | 401 | That token has expired. Refresh it, or connect the app again. |
| `no_access` | 403 | This credential does not reach that. Ask the person who made it for access. |
| `not_found` | 404 | No such record in the companies this credential reaches. |
| `out_of_scope` | 404 | No such company in the companies this credential reaches. |
| `invalid` | 422 | Some fields were refused. See fields. |
| `rate_limited` | 429 | Too many calls this minute. Wait and try again. |
| `not_connected` | 409 | This company has not connected that provider yet. |
Related
- List tables: Every raw table, by the provider that produced it, with its columns, its grain and whether this company has it connected.
- Export table: One raw table as a CSV file for a company and a date range, up to 50,000 rows, with its caveat in the last lines.
- The same records in the app: the Raw data board.
- How the API fits together: the model, API keys, errors and the MCP server.