Create a new in-memory table

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

Creates a new in-memory table from column 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 Caslib name for which tables are being requested.

serverName
string
true

Server name for which tables are being requested.

Query Parameters

NameTypeRequiredDescription
sessionId
string
false

Session ID used for session table creation. Scope of the session table may be optionally modified to make the table global.

Request Body

Inputs when creating an empty in-memory table from column information.

NameTypeRequiredDescription
version
integer
false

The version of the schema.

tableName
string
false

Name of the output table to be created.

replace
boolean
false

If true, any pre-existing loaded table with the same name is replaced. Defaults to false.

columns
array [CAS Column]
false

Column information.

Responses

StatusMeaningDescription
201CreatedInformation about the newly created table.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.