Introducing Agents.·Read
Getting StartedKey ConceptsHow-to GuidesCLITrickest SDKSandbox SDKAPI ReferenceChangelog
Query database table data

Query database table data

Reads rows from a live database table via the reporting backend, with a TQL filter, ordering, column selection, and pagination.

GET/api/database-tables/{tableId}/data
Path parameters
tableIdstringrequired
Query parameters
offsetintegerrequireddefault: 0
limitintegerrequireddefault: 24
order_bystringrequired
qstringrequired
selectstringrequired
query_idstring

Request

curl
curl -X GET https://trickest.io/api/database-tables/{tableId}/data \
  -H "Authorization: Bearer $TRICKEST_TOKEN"

Responses

200Query result rows from the reporting backend
columnsstring[]required
rowsobject[]required
row_countnumberrequired
400Bad Request – validation error or malformed input
codestringrequired
messagestringrequired
detailsobject

Field-level detail when the error is a validation failure.

401Unauthorized – missing or expired token
codestringrequired
messagestringrequired
detailsobject

Field-level detail when the error is a validation failure.

403Forbidden – insufficient permissions
codestringrequired
messagestringrequired
detailsobject

Field-level detail when the error is a validation failure.

409Conflict – request cannot be completed in the resource's current state
codestringrequired
messagestringrequired
detailsobject

Field-level detail when the error is a validation failure.

429Too Many Requests – rate limited
codestringrequired
messagestringrequired
detailsobject

Field-level detail when the error is a validation failure.

500Internal Server Error
codestringrequired
messagestringrequired
detailsobject

Field-level detail when the error is a validation failure.

PreviousDatabaseCopy a database.DatabaseNextPromote a database table to live (SDK alias)