---
title: "Download Asynchronous Blockchain SQL Results"
method: GET
path: "/gateway/v1/onchain/sql/jobs/{job_id}/results"
tags: ["Onchain"]
---

# Download Asynchronous Blockchain SQL Results

`GET /gateway/v1/onchain/sql/jobs/{job_id}/results`

## Request

- Base URL: `https://api.asksurf.ai`
- URL: `https://api.asksurf.ai/gateway/v1/onchain/sql/jobs/{job_id}/results`
- Auth: HTTP bearer

Returns the retained complete result as the standard JSON data envelope or as a CSV attachment. Results are available for 24 hours and are isolated to the authenticated tenant or user.

## Path parameters

- `job_id` string, uuid, required: Asynchronous SQL job identifier

## Query parameters

- `format` 'json' | 'csv': Result representation

## Response `200`

Completed SQL job result

- DataResponseOnchainRow
  - `$schema` string, uri: A URL to the JSON Schema for this object.
  - `data` object[], nullable, required
  - `meta` OffsetMeta, required
    - `cached` boolean, required: Whether this response was served from cache
    - `credits_used` integer, required: Credits deducted for this request
    - `empty_reason` string: Hint explaining why the data array is empty, when applicable
    - `has_more` boolean: Whether more items may exist beyond this response. For offset-paged endpoints, continue with a larger offset. For time-series endpoints without offset/cursor controls, true means the requested time range hit an upstream cap; narrow from/to to continue. Omitted when exhaustion cannot be proven.
    - `limit` integer, required: Maximum number of items returned in this response
    - `offset` integer, required: Number of items skipped (pagination offset)
    - `total` integer: Total number of matching items (before pagination). Omitted when total is unknown.
    - `watermark` integer: Warehouse watermark (Unix seconds) this response was computed at, on warehouse-backed endpoints (e.g. Hyperliquid /trades/aggregate) — rows up to this time come from the warehouse, newer rows from the live tail. Omitted elsewhere.

## Other responses

- `default`: Error

---

[API](https://skmtc.dev/asksurf/apis/asksurf-public-rest-api.md) - [All operations](https://skmtc.dev/asksurf/apis/asksurf-public-rest-api/llms.txt) - [OpenAPI document](https://skmtc.dev/asksurf/apis/asksurf-public-rest-api/revisions/91774fdd5302?raw)