Get preview result for a specific database table
GET {{baseUrl}}/api/datasources/:id/catalog/namespaces/:namespaceId/tables/:tableId/result?includeRowCount=false&fields=Excepteur Lorem
Get preview result for a specific database table. You obtain the authorization token needed to execute the request using POST /auth/login; You pass the authorization token in the request header. You specify the datasource ID, namespace ID and table ID in the path of the request; You obtain the preview result using GET /datasources/{id}/catalog/namespaces/{namespaceId}/tables/{tableId}/result.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
includeRowCount | boolean | Include table row count | |
fields | string | Comma separated top-level field whitelist. This allows client to selectively retrieve part of the response model. If specified, extra filtering will be applied, and for top-level object (if root model is an array, each array element), only the listed fields will be kept in the response. e.g. "id,elements" means to keep only the "id" field and the whole "elements" array field, omitting all other fields of top-level response model. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
X-MSTR-AuthToken | string | (Required) Authorization token | |
X-MSTR-ProjectID | string | (Required) Project ID |
RESPONSES
status: OK
{"columns":[{"name":"occaecat fugiat ","dataType":{"type":"time_stamp","scale":-60341045,"precision":-15816750}},{"name":"officia sit Lorem eu","dataType":{"type":"double_double","scale":41775405,"precision":-56972210}}],"totalRowCount":-83208113,"data":[[],[]],"name":"reprehenderit id","id":"mollit commodo veniam voluptate sed"}