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}/dataPath parameters
tableIdstringrequiredQuery parameters
offsetintegerrequireddefault: 0limitintegerrequireddefault: 24order_bystringrequiredqstringrequiredselectstringrequiredquery_idstringRequest
curl
curl -X GET https://platform.trickest.com/api/database-tables/{tableId}/data \
-H "Authorization: Bearer $TRICKEST_TOKEN"Responses
200Query result rows from the reporting backend
columnsstring[]requiredrowsobject[]requiredrow_countnumberrequired400Bad Request – validation error or malformed input
codestringmessagestring401Unauthorized – missing or expired token
codestringmessagestring500Internal Server Error
codestringmessagestring