Introducing Agents.·Read
Getting StartedKey ConceptsHow-to GuidesCLITrickest SDKSandbox SDKAPI ReferenceChangelog
Query a database's Live Table data.

Query a database's Live Table data.

Reads rows from a Live Table, with TQL filter, ordering, column selection, and pagination.

GET/api/solutions/{solutionId}/data
Path parameters
solutionIdstringrequired
Query parameters
dataset_idstringrequired
offsetintegerrequireddefault: 0
limitintegerrequireddefault: 24
order_bystringrequired
qstringrequired
selectstringrequired
query_idstring

Request

curl
curl -X GET https://trickest.io/api/solutions/{solutionId}/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.

PreviousDatabaseTruncate a Live Table.DatabaseNextList a database's Live Tables.