Get the distinct count for all columns

get/servers/{serverName}/caslibs/{caslibName}/tables/{tableName}/distinctCounts

Internal-Use Only

Returns a collection of distinct count information for the columns in a loaded CAS table. Supports SAS standard paging query parameters. Supports SAS standard paging query parameters, sorting, and filtering. Schema of items returned in the response collection is included below, and are of type application/vnd.sas.cas.column.distinct.count+json.

Request Samples

Response Samples

200
application/vnd.sas.collection+json
1{
2  "version": 1,
3  "columnName": "2016/17",
4  "distinctCount": 30,
5  "missingCount": 0,
6  "truncated": false,
7  "links": [
8    {
9      "method": "GET",
10      "rel": "up",
11      "href": "/casManagement/servers/cas-shared-default/caslibs/testlib/tables/NBA_2016_TEAMSALARIES/columns/2016/17",
12      "uri": "/casManagement/servers/cas-shared-default/caslibs/testlib/tables/NBA_2016_TEAMSALARIES/columns/2016/17",
13      "type": "application/vnd.sas.cas.column"
14    },
15    {
16      "method": "GET",
17      "rel": "self",
18      "href": "/casManagement/servers/cas-shared-default/caslibs/testlib/tables/NBA_2016_TEAMSALARIES/columns/2016/17/distinctCount",
19      "uri": "/casManagement/servers/cas-shared-default/caslibs/testlib/tables/NBA_2016_TEAMSALARIES/columns/2016/17/distinctCount",
20      "type": "application/vnd.sas.cas.column.distinct.count"
21    }
22  ]
23}

Path Parameters

Name	Type	Required	Description
caslibName	string	true	The name of the Caslib containing the table.
serverName	string	true	The name of the server containing the Caslib.
tableName	string	true	The name of table for which distinct count info is requested.

Query Parameters

Name	Type	Required	Description
sessionId	string	false	The optional ID of the session containing the Caslib. If unspecified, only tables in global caslibs will be accessible.
limit	integer	false	Maximum number of items to return in this page of results. The actual number of returned items can be less if the collection has been exhausted. Defaults to 10.
start	integer	false	The starting index of the first item in a page. Defaults to 0.

Responses

Status	Meaning	Description
200	OK	The requested table's distinct and missing count information for all columns was returned.	Schema
404	Not Found	The requested CAS server or Caslib does not exist.
409	Conflict	The request could not be completed due to a conflict with the current state of the resource. Details are included in the response body.