Get latest query run result data

Returns the actual result data from the query’s latest successful run. Equivalent to finding the latest successful run and calling GET /query-runs//data.

GET /queries/{id}/latest/data

Get latest query run result data

cURL

curl --request GET \
  --url https://api.flipsidecrypto.xyz/public/v3/queries/{id}/latest/data \
  --header 'x-api-key: <api-key>'

200

{
  "queryRunId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "status": "<string>",
  "totalRowCount": 123,
  "returnedRowCount": 123,
  "columns": [
    null
  ],
  "rows": [
    {}
  ],
  "startedAt": "2023-11-07T05:31:56Z",
  "completedAt": "2023-11-07T05:31:56Z"
}

Authorizations

x-api-key · string · header · required

Path Parameters

id · string<uuid> · required

Query Parameters

limit · string

Maximum number of rows to return

offset · string

Number of rows to skip (default: 0)

Response

200

application/json

Query result data from the latest successful run

queryRunId · string<uuid> · required

status · string · required

totalRowCount · integer | null · required

returnedRowCount · integer · required

columns · null[] | null · required

rows · object[] · required

Show child attributes

startedAt · string<date-time> | null

completedAt · string<date-time> | null