Create a new in-memory table
post/servers/{serverName}/caslibs/{caslibName}/tables
Creates a new in-memory table from column information.
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}
Name | Type | Required | Description |
---|---|---|---|
caslibName | string | true | The Caslib name for which tables are being requested. |
serverName | string | true | Server name for which tables are being requested. |
Name | Type | Required | Description |
---|---|---|---|
sessionId | string | false | Session ID used for session table creation. Scope of the session table may be optionally modified to make the table global. |
Inputs when creating an empty in-memory table from column information.
Name | Type | Required | Description |
---|---|---|---|
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. |
Status | Meaning | Description | ||
---|---|---|---|---|
201 | Created | Information about the newly created table. | Schema | |
400 | Bad Request | The request was invalid. | 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. |