Get a table

get/servers/{serverName}/caslibs/{caslibName}/tables/{tableName}
Internal-Use Only

Retrieves table information.

Request Samples

1

Response Samples

1{
2  "version": 3,
3  "name": "CUSTOMERS",
4  "tableReference": {
5    "tableUri": "/dataTables/dataSources/cas~fs~cas-shared-default~fs~CASUSER/tables/CUSTOMERS",
6    "sessionId": "ad0b5228-cc89-874c-8893-c1c420f6e0cb",
7    "sourceCaslibName": "CASUSER",
8    "sourceTableName": "CUSTOMERS.sashdat"
9  },
10  "serverName": "cas-shared-default",
11  "caslibName": "CASUSER",
12  "scope": "global",
13  "state": "loaded",
14  "repeated": false,
15  "created": "2017-04-11T17:17:15.373000Z",
16  "lastModified": "2017-04-11T18:50:42.106000Z",
17  "createdBy": "userid",
18  "lastModifiedBy": "userid",
19  "lastAccessed": "2017-04-11T19:12:13.102000Z",
20  "sourceLastModified": "2017-03-12T03:43:22.101000Z",
21  "label": "My table label",
22  "rowCount": 160,
23  "columnCount": 9,
24  "characterSet": "UTF8",
25  "encoding": "utf-8",
26  "disconnected": false,
27  "attributes": {
28    "owner": "someuser",
29    "size": 115704,
30    "encryption": "NONE",
31    "time": "18Nov2016:15:27:28",
32    "group": "users"
33  },
34  "links": [
35    {
36      "method": "GET",
37      "rel": "up",
38      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables",
39      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables",
40      "type": "application/vnd.sas.collection",
41      "itemType": "application/vnd.sas.cas.table"
42    },
43    {
44      "method": "GET",
45      "rel": "self",
46      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS",
47      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS",
48      "type": "application/vnd.sas.cas.table"
49    },
50    {
51      "method": "DELETE",
52      "rel": "delete",
53      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS",
54      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS"
55    },
56    {
57      "method": "PUT",
58      "rel": "updateState",
59      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/state",
60      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/state"
61    },
62    {
63      "method": "PUT",
64      "rel": "updateScope",
65      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/scope",
66      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/scope",
67      "responseType": "application/json;text/plain"
68    },
69    {
70      "method": "GET",
71      "rel": "summaryStatistics",
72      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/summaryStatistics",
73      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/summaryStatistics",
74      "type": "application/vnd.sas.collection",
75      "itemType": "application/vnd.sas.cas.column"
76    },
77    {
78      "method": "GET",
79      "rel": "distinctCount",
80      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/distinctCount",
81      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/distinctCount",
82      "type": "application/vnd.sas.collection",
83      "itemType": "application/vnd.sas.cas.column"
84    },
85    {
86      "method": "GET",
87      "rel": "columns",
88      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/columns",
89      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/columns",
90      "type": "application/vnd.sas.collection",
91      "itemType": "application/vnd.sas.cas.column"
92    },
93    {
94      "method": "GET",
95      "rel": "dataTable",
96      "href": "/dataTables/dataSources/cas~fs~cas-shared-default~fs~CASUSER/tables/CUSTOMERS",
97      "uri": "/dataTables/dataSources/cas~fs~cas-shared-default~fs~CASUSER/tables/CUSTOMERS",
98      "type": "application/vnd.sas.data.table"
99    }
100  ]
101}

Path Parameters

NameTypeRequiredDescription
caslibName
string
true

The name of the Caslib containing the table.

serverName
string
true

Server name for which the table is being requested.

tableName
string
true

Table name requested.

Query Parameters

NameTypeRequiredDescription
sessionId
string
false

Session ID (used when session-specific table is being requested).

detailGroups
array [string]
false

A comma-separated list of detail groups to return in the representation. Some detail groups require more time to retrieve. This parameter allows opting-in to the following detail groups in cases where they are not already included: all - Include all detail groups unloaded Columns - Include column counts for unloaded tables. This information is retrieved if available from the source. unloadedRows - Include row counts for unloaded tables. This information is retrieved if available from the source. Row counts from HDFS are not provided.

Allowed values:
allunloadedColumnsunloadedRows

Responses

StatusMeaningDescription
200OKThe request succeeded. The table with the specified name was returned. In the case that the loaded table exists in both session and global scope, the single session scope table will be returned. This is consistent with CAS, which will always operate against the table in session scope when both a global and session scope table with the same name exists.Schema
400Bad RequestThe request was invalid.Schema
404Not FoundThe requested CAS server or Caslib does not exist.
409ConflictThe request could not be completed due to a conflict with the current state of the resource. Details are included in the response body.