Get a table

get/dataSources/{dataSourceId}/tables/{tableId}
Internal-Use Only

Returns information about a single table based on its unique name.

Request Samples

1

Response Samples

1{
2  "name": "AIRLINES",
3  "label": "Airlines",
4  "providerId": "cas",
5  "dataSourceId": "MYCASLIB",
6  "type": "dataTable",
7  "creationTimeStamp": "0001-01-01T00:00:00Z",
8  "modifiedTimeStamp": "0001-01-01T00:00:00Z",
9  "attributes": {
10    "loaded": true,
11    "characterSet": "UTF8",
12    "global": true,
13    "caslibId": "MYCASLIB",
14    "rowCount": 6048,
15    "columnCount": 8,
16    "sessionId": "6a5ebbb5-0f3a-0a4d-a433-17e44f65e34f",
17    "encoding": "utf-8",
18    "serverId": "cas"
19  },
20  "version": 2,
21  "links": [
22    {
23      "method": "GET",
24      "rel": "self",
25      "href": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES",
26      "uri": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES",
27      "type": "application/vnd.sas.data.table"
28    },
29    {
30      "method": "GET",
31      "rel": "alternate",
32      "href": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES",
33      "uri": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES",
34      "type": "application/vnd.sas.data.table.summary"
35    },
36    {
37      "method": "GET",
38      "rel": "connectionAttributes",
39      "href": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES",
40      "uri": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES",
41      "type": "application/vnd.sas.attributes"
42    },
43    {
44      "method": "GET",
45      "rel": "sessionScoped",
46      "href": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES?sessionId=6a5ebbb5-0f3a-0a4d-a433-17e44f65e34f",
47      "uri": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES?sessionId=6a5ebbb5-0f3a-0a4d-a433-17e44f65e34f",
48      "type": "application/vnd.sas.data.table"
49    },
50    {
51      "method": "GET",
52      "rel": "session",
53      "href": "/dataSources/providers/cas/sources/cas-shared-default/sessions/6a5ebbb5-0f3a-0a4d-a433-17e44f65e34f",
54      "uri": "/dataSources/providers/cas/sources/cas-shared-default/sessions/6a5ebbb5-0f3a-0a4d-a433-17e44f65e34f",
55      "type": "application/vnd.sas.data.session"
56    },
57    {
58      "method": "GET",
59      "rel": "up",
60      "href": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables",
61      "uri": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables",
62      "type": "application/vnd.sas.collection",
63      "itemType": "application/vnd.sas.data.table"
64    },
65    {
66      "method": "GET",
67      "rel": "source",
68      "href": "/dataSources/providers/cas/sources/cas-shared-default",
69      "uri": "/dataSources/providers/cas/sources/cas-shared-default",
70      "type": "application/vnd.sas.data.source"
71    },
72    {
73      "method": "GET",
74      "rel": "rows",
75      "href": "/rowSets/tables/cas~cas-shared-default~fs~MYCASLIB~fs~AIRLINES/rows",
76      "uri": "/rowSets/tables/cas~cas-shared-default~fs~MYCASLIB~fs~AIRLINES/rows",
77      "type": "application/vnd.sas.collection",
78      "itemType": "application/vnd.sas.data.row"
79    },
80    {
81      "method": "GET",
82      "rel": "rowSet",
83      "href": "/rowSets/tables/cas~cas-shared-default~fs~MYCASLIB~fs~AIRLINES/rowSet",
84      "uri": "/rowSets/tables/cas~cas-shared-default~fs~MYCASLIB~fs~AIRLINES/rowSet",
85      "type": "application/vnd.sas.data.row.set"
86    },
87    {
88      "method": "GET",
89      "rel": "columns",
90      "href": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES/columns",
91      "uri": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB/tables/AIRLINES/columns",
92      "type": "application/vnd.sas.collection",
93      "itemType": "application/vnd.sas.data.column.summary"
94    },
95    {
96      "method": "GET",
97      "rel": "provider",
98      "href": "/dataTables/providers/cas",
99      "uri": "/dataTables/providers/cas",
100      "type": "application/vnd.sas.data.provider"
101    },
102    {
103      "method": "GET",
104      "rel": "dataSource",
105      "href": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB",
106      "uri": "/dataTables/dataSources/cas~cas-shared-default~fs~MYCASLIB",
107      "type": "application/vnd.sas.data.source"
108    }
109  ]
110}

Path Parameters

NameTypeRequiredDescription
dataSourceId
string
true

The name of the data source. Its format is providerIdfssourceIdfslibraryName. The format is a tilda encoded form composed of the following: providerId: name of the provider. Examples: cas, Compute Use GET /dataSources/providers to see the list of available providers. sourceId: refers to server id in case of cas and computeContextId in case of compute. An example sourceId for cas is cas-shared-default. An example sourceId for Compute is 97751fe6-8313-487f-865a-f941c8a75f8f (SAS Studio Compute Context). Use GET /dataSources/providers/{providerId}/sources to see the list of available sources. libraryName: name of the library. Use GET /dataSources/providers/{providerId}/sources/{sourceId}/children to see the the list of available libraries. An example dataSourceId for cas is casfscas-shared-defaultfsmodels. An example dataSourceId for Compute is Computefs97751fe6-8313-487f-865a-f941c8a75f8ffssashelp.

tableId
string
true

The URL encoded (i.e. Percent encoded) form of the table's name.

Query Parameters

NameTypeRequiredDescription
preserveSession
boolean
false

This has effect only when the sessionId query parameter is not specified. If this is set to true, no sessionId is provided, the session created by the data service provider is not be terminated. All returned links, except the "self" link, have the sessionId query parameter added to their respective URIs. Also, they contain an additional session link to the application/vnd.sas.data.session resource that corresponds to the provided sessionId. If set to false, or not specified, the session is be terminated after the request is complete. The default is false.

sessionId
string
false

The unique identifier of the session used to access the data service provider's backing service. When this is not specified, the data service provider creates a temporary session, and then terminates it after the request is complete. If this is specified, all returned links, except the "self" link, have the sessionId query parameter added to their respective URIs. Also, they contain an additional session link to the application/vnd.sas.data.session resource that corresponds to the provided sessionId.

Responses

StatusMeaningDescription
200OKThe request succeeded.Schema
404Not FoundOne of the following resources does not exist: <ul> <li>The data source</li> <li>The table</li> </ul> Schema