Async SQL job status

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

curl -X POST https://api.orthogonal.com/v1/run \
-H 'Authorization: Bearer orth_live_••••' \
-H 'Content-Type: application/json' \
-d '{
"api": "surf",
"path": "",
"method": "GET"
}'
{
"success": true,
"data": {
"data": { … },
"meta": { … },
"$schema": "https://api.asksurf.ai/schemas/DataObjectResponseAsyncSQLJobResponse.json"
}
}
A real response, recorded when Orthogonal checked this endpoint.

Free

Calls cost nothing.

About this endpoint

Get Asynchronous Blockchain SQL Job: Returns durable job status, elapsed time, ClickHouse progress counters, retry semantics, and result links. Polling never starts another ClickHouse execution.

Path parameters

Response types

More from Surf API

  1. KOL rankingGET/gateway/v1/smart-money/kol/ranking$0.01308 per callFixed
  2. Liquidation chartGET/gateway/v1/market/liquidation/chart$0.01308 per callFixed
  3. Blockchain SQL queryPOST/gateway/v1/onchain/sql$0.02616 per callFixed
  4. KOL call historyGET/gateway/v1/smart-money/kol/history$0.01308 per callFixed
  5. Order book depthGET/gateway/v1/exchange/depth$0.00654 per callFixed
  6. Latest company financialsGET/gateway/v1/equity/latest-financialsUp to $0.03924 per callResponse-based
  7. Web page fetchGET/gateway/v1/web/fetch$0.00654 per callFixed
  8. Matched market pairsGET/gateway/v1/prediction-market/matching/pairs$0.02616 per callFixed
  9. Polymarket wallet positionsGET/gateway/v1/prediction-market/polymarket/positions$0.02616 per callFixed
  10. Hyperliquid trader leaderboardGET/gateway/v1/hyperliquid/leaderboard$0.02616 per callFixed
  11. Perpetual contract snapshotGET/gateway/v1/exchange/perp$0.00654 per callFixed
  12. KOL activityGET/gateway/v1/smart-money/kol/activity$0.01308 per callFixed
All 145 Surf API endpoints