get_signed_sql_drilldown
Read-only
Fetch the rows behind an event-web drilldown from its server-minted query token.
Some `get_company_event_web` nodes carry `signed_query_url` in their `fetch` hint —
an opaque, tamper-proof link the backend minted for exactly that node. This tool is
the zero-planning rung of the chain: no query to compose, the rows come back
directly. Pass either the full `signed_query_url` or just its `t` parameter; the
URL form is unwrapped automatically. A token that came from a
SAVED request rather than the event web belongs to `run_saved_query` instead — same
endpoint, but it replays every query in the saved row in one call.
Returns {"format": "table", "count": N, "rows": [...]} — rows only, never the
underlying SQL. For contextual drilldowns the NEW record is flagged
`is_new_record: true` and the remaining rows are the prior/context records to read
it against (the node's `signed_query_context` describes what they are).
CITE WHAT YOU PUBLISH: the rows may carry `_source_*` columns — `_source_url`,
`_source_filed_at`, `_source_document_id`, `_source_citations` — and the response a
`sources` block naming each relation, its grain, and whether it is `traceable` per
"row" or only as a "cohort". That is the provenance of the numbers, not padding:
quote `_source_url` when the user asks where a figure came from, and for anything
you are about to publish — or the moment they ask for the filing, the quote, or
"how do you know" — pass `sources.relations[].relation` plus each row's
identifying columns (the grain AND its date) to `trace_data_sources`, which
resolves them to the source document, the
section, or the verified quote behind the number. `get_document_section` then opens
the exact speaker turn a transcript citation points at.
HTTP 403 means the token is invalid or tampered — do not retry with an altered
token; re-fetch the event web for a fresh link instead.
`values` and `prompt` re-aim a token that is a PLACEHOLDER TWIN at other entities;
the response then carries `parameters` (what was substituted) alongside `rows`;
echo those to the user. A 422 means the request could not be
mapped onto the token's slots. The full slot vocabulary of a SAVED row lives in
`list_saved_queries` -> `metadata.parameters`, and replaying a saved row is
`run_saved_query`, not this tool.
An uncapped drilldown that fans out to constituents can return tens of thousands
of rows and stall the client for minutes — pass `max_rows`.
Requires auth (your MCP client attaches the OAuth bearer automatically) — unlike
`get_company_event_web`, which is public: the web hands out the LINK to anyone, but
following it to the underlying rows is for signed-in users. A signed-out caller gets
a not-authenticated error, not rows; the fix is signing in, never a different token.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| prompt | No | Placeholder-twin tokens only: natural-language fill for slots `values` did not cover, e.g. "the same rows for KSS". Omit for a plain event-web link. | |
| values | No | Placeholder-twin tokens only (preferred over prompt): {slot name: typed value}, filled deterministically, e.g. {"symbol": "KSS"}. Omit for a plain link. | |
| max_rows | No | Cap on rows returned, e.g. 500; the response then carries row_count and truncated: true. Pass it on any drilldown that can fan out to constituents. | |
| encrypted_query_token | Yes | A node's `signed_query_url` from get_company_event_web, or just its `t` parameter — verbatim. Never construct or edit one; never pass SQL. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | Result rows (cell values are strings or null). May carry _source_* citation columns. Null on a replay entry whose token failed (see `error`). | |
| count | No | Rows returned in `rows`. | |
| format | No | "table". | |
| sources | No | Provenance block; present when the numbers trace to documents. | |
| row_count | No | Full row count when `truncated` (max_rows sliced the result). | |
| truncated | No | ||
| parameters | No | Values substituted into a placeholder twin; echo them to the user. | |
| ignored_values | No | Keys in `values` this token does not use. | |
| defaulted_parameters | No | Slots that kept the saved example value. |