Get a list of source files or tables
Returns a collection of source files or tables accessible through the data source defined for the Caslib. For path-based caslibs, this list will include files in the file system. For non-path-based caslibs, such as database data sources, this list will include database tables. The list is returned without regard to the loaded or unloaded state of the source file or table. Sorting and filtering are not supported. SAS standard paging query parameters are supported. Schema of items returned in the response collection is included below, and are of type application/vnd.sas.cas.source.table+json.
1{2 "links": [3 {4 "method": "GET",5 "rel": "up",6 "href": "/casManagement/servers/cas-shared-default/caslibs/Public/",7 "uri": "/casManagement/servers/cas-shared-default/caslibs/Public/",8 "type": "application/vnd.sas.cas.caslib"9 },10 {11 "method": "GET",12 "rel": "self",13 "href": "/casManagement/servers/cas-shared-default/caslibs/Public/sources?excludeItemLinks=false&start=0&limit=2",14 "uri": "/casManagement/servers/cas-shared-default/caslibs/Public/sources?excludeItemLinks=false&start=0&limit=2",15 "type": "application/vnd.sas.collection",16 "itemType": "application/vnd.sas.cas.source.table"17 },18 {19 "method": "GET",20 "rel": "collection",21 "href": "/casManagement/servers/cas-shared-default/caslibs/Public/sources",22 "uri": "/casManagement/servers/cas-shared-default/caslibs/Public/sources",23 "type": "application/vnd.sas.collection",24 "itemType": "application/vnd.sas.cas.source.table"25 },26 {27 "method": "GET",28 "rel": "next",29 "href": "/casManagement/servers/cas-shared-default/caslibs/Public/sources?excludeItemLinks=false&start=2&limit=2",30 "uri": "/casManagement/servers/cas-shared-default/caslibs/Public/sources?excludeItemLinks=false&start=2&limit=2",31 "type": "application/vnd.sas.collection"32 },33 {34 "method": "GET",35 "rel": "last",36 "href": "/casManagement/servers/cas-shared-default/caslibs/Public/sources?excludeItemLinks=false&start=16&limit=2",37 "uri": "/casManagement/servers/cas-shared-default/caslibs/Public/sources?excludeItemLinks=false&start=16&limit=2",38 "type": "application/vnd.sas.collection"39 }40 ],41 "name": "sources",42 "accept": "application/vnd.sas.cas.source.table",43 "count": 18,44 "items": [45 {46 "name": "MAILORDER.sashdat",47 "attributes": {48 "owner": "userId",49 "size": 244,50 "encryption": "NONE",51 "permission": "-rwxr-xr-x",52 "time": "15Sep2017:20:29:10",53 "group": "mygroup"54 },55 "links": [56 {57 "method": "GET",58 "rel": "up",59 "href": "/casManagement/servers/cas-shared-default/caslibs/Public/sources",60 "uri": "/casManagement/servers/cas-shared-default/caslibs/Public/sources",61 "type": "application/vnd.sas.collection",62 "itemType": "application/vnd.sas.cas.source.table"63 },64 {65 "method": "GET",66 "rel": "self",67 "href": "/casManagement/servers/cas-shared-default/caslibs/Public/sources/MAILORDER.sashdat",68 "uri": "/casManagement/servers/cas-shared-default/caslibs/Public/sources/MAILORDER.sashdat",69 "type": "application/vnd.sas.cas.source.table"70 }71 ]72 },73 {74 "name": "mysasdata.sas7bdat",75 "attributes": {76 "owner": "userId",77 "size": 128,78 "permission": "-rw-r--r--",79 "time": "15Sep2017:20:29:05",80 "group": "mygroup"81 },82 "links": [83 {84 "method": "GET",85 "rel": "up",86 "href": "/casManagement/servers/cas-shared-default/caslibs/Public/sources",87 "uri": "/casManagement/servers/cas-shared-default/caslibs/Public/sources",88 "type": "application/vnd.sas.collection",89 "itemType": "application/vnd.sas.cas.source.table"90 },91 {92 "method": "GET",93 "rel": "self",94 "href": "/casManagement/servers/cas-shared-default/caslibs/Public/sources/mysasdata.sas7bdat",95 "uri": "/casManagement/servers/cas-shared-default/caslibs/Public/sources/mysasdata.sas7bdat",96 "type": "application/vnd.sas.cas.source.table"97 }98 ]99 }100 ],101 "limit": 2,102 "version": 2103}
Name | Type | Required | Description |
---|---|---|---|
caslibName | string | true | The Caslib name for which source tables are being requested. |
serverName | string | true | Server name for which source tables are being requested. |
Name | Type | Required | Description |
---|---|---|---|
sessionId | string | false | Session ID (used when session-specific tables are also desired in results). |
excludeItemLinks | boolean | false | Determines whether item links are excluded from results. Defaults to false. |
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. |
Status | Meaning | Description | ||
---|---|---|---|---|
200 | OK | The request succeeded. The list of source files or tables for the requested CAS server, CAS library, and optional session was returned. | 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. |