Async SQL job submit

POST/gateway/v1/onchain/sql/jobs

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

$0.02616per call

Every call costs the same.

You aren't charged for failed calls. A wallet payment for a failed call is refunded.

About this endpoint

Submit Asynchronous Blockchain SQL Job: Accepts a read-only SQL query for durable background execution. Returns a stable job and ClickHouse query ID immediately. Reusing the same Idempotency-Key, or submitting SQL equivalent after whitespace and operator-spacing normalization with the same max_rows while its retained job exists, returns the existing job without starting another execution. Accepted jobs remain queued while the owner's cluster-wide ClickHouse execution budget is occupied by synchronous or asynchronous work.

Body 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