SQL

sql.results

Results of a SQL run

Details

Endpoint: GET /v1/execution/:execution_id/results
Credits: Free
Rate class: Light. Counts against your light requests per second.
Also called: /api/v1/execution/:execution_id/results

Rows of a finished run with result.metadata (column names and types, row count, timings) and as_of. Page with limit (default 1000, max 100000) and offset; next_uri points at the next page. Pick columns with columns=a,b and sort with sort_by="col desc". rows=array returns each row as an array in column order. Before the run finishes this returns its status with result null.

Parameters

Name	Type	Description
execution_idrequired	string
limit	integer
offset	integer
columns	string
sort_by	string
rows	string	One of "object", "array".
wait_ms	integer

Request

Send your key in the x-api-key header, or leave it out to use the keyless tier.

curl

curl "https://api.tide.ad/v1/execution/01019A4C0F2A8B3C4D5E6F708192A3B4C5/results?limit=100" \
  -H "x-api-key: YOUR_API_KEY"

TypeScript

const res = await fetch("https://api.tide.ad/v1/execution/01019A4C0F2A8B3C4D5E6F708192A3B4C5/results?limit=100", {
  headers: {
    "x-api-key": process.env.TIDE_API_KEY!,
  },
});
const data = await res.json();

Response

No example response is available for this method yet.