Get a list of data sources

get/providers/{providerId}/sources

Returns a collection of sources. Standard paging, filtering, and sorting options are provided. The members of this collection use application/vnd.sas.data.source media type representation.

Request Samples

1

Response Samples

1{
2 "name": "sources",
3 "accept": "application/vnd.sas.data.source",
4 "count": 1,
5 "version": 1,
6 "items": [
7 {
8 "id": "cas",
9 "name": "cas",
10 "type": "casServer",
11 "providerId": "cas",
12 "description": "controller",
13 "hasTables": true,
14 "hasEngines": false,
15 "attributes": {
16 "port": "8850",
17 "host": "server.example.com"
18 },
19 "version": 1,
20 "links": [
21 {
22 "method": "GET",
23 "rel": "self",
24 "href": "/dataSources/providers/cas/sources/cas",
25 "uri": "/dataSources/providers/cas/sources/cas",
26 "type": "application/vnd.sas.data.source"
27 },
28 {
29 "method": "GET",
30 "rel": "alternate",
31 "href": "/dataSources/providers/cas/sources/cas",
32 "uri": "/dataSources/providers/cas/sources/cas",
33 "type": "application/vnd.sas.data.source.summary"
34 },
35 {
36 "method": "GET",
37 "rel": "status",
38 "href": "/casManagement/servers/cas/status",
39 "uri": "/casManagement/servers/cas/status",
40 "responseType": "application/json"
41 },
42 {
43 "method": "GET",
44 "rel": "tables",
45 "href": "/dataTables/dataSources/cas~fs~cas/tables",
46 "uri": "/dataTables/dataSources/cas~fs~cas/tables",
47 "type": "application/vnd.sas.collection",
48 "itemType": "application/vnd.sas.data.table"
49 },
50 {
51 "method": "GET",
52 "rel": "up",
53 "href": "/dataSources/providers/cas/sources",
54 "uri": "/dataSources/providers/cas/sources",
55 "type": "application/vnd.sas.collection",
56 "itemType": "application/vnd.sas.data.source"
57 },
58 {
59 "method": "GET",
60 "rel": "children",
61 "href": "/dataSources/providers/cas/sources/cas-shared-default/children",
62 "uri": "/dataSources/providers/cas/sources/cas-shared-default/children",
63 "type": "application/vnd.sas.collection",
64 "itemType": "application/vnd.sas.data.source"
65 }
66 ]
67 }
68 ],
69 "links": [
70 {
71 "method": "GET",
72 "rel": "collection",
73 "href": "/dataSources/providers/cas/sources",
74 "uri": "/dataSources/providers/cas/sources",
75 "type": "application/vnd.sas.collection"
76 },
77 {
78 "method": "GET",
79 "rel": "self",
80 "href": "/dataSources/providers/cas/sources?start=0&limit=10",
81 "uri": "/dataSources/providers/cas/sources?start=0&limit=10",
82 "type": "application/vnd.sas.collection",
83 "itemType": "application/vnd.sas.data.source"
84 },
85 {
86 "method": "GET",
87 "rel": "up",
88 "href": "/dataSources/providers/cas",
89 "uri": "/dataSources/providers/cas",
90 "type": "application/vnd.sas.data.provider"
91 }
92 ]
93}

Path Parameters

NameTypeRequiredDescription
providerId
string
true

The ID for the provider.

Query Parameters

NameTypeRequiredDescription
filter
string<filter-criteria>
false

Filter criteria for returned sources. The valid filter fields are name and type if supported by the provider. The supported functions are and, or, not, eq, lt, le, gt, ge, contains, startsWith, endsWith and isNull. Sample queries include the following:

  • Search by name starting with: /dataSources/providers/{providerId}/sources?filter=startsWith(name, 'source')
  • Search by name: /dataSources/providers/{providerId}/sources?filter=eq(name, 'source1')
  • Search for multiple sources: /dataSources/providers/{providerId}/sources?filter=in(name, 'source1', 'source2', 'source3')
limit
integer
false

Maximum number of objects to return. Defaults to 10.

sortBy
string<sort-criteria>
false

Sort returned sources. The sort criteria supports the following fields in either ascending or descending order (name, type, createdBy, modifiedBy, creationTimeStamp, and modifiedTimeStamp). Sample sorts include the following:

  • Sort ascending by source name: /dataSources/providers/{providerId}/sources?sortBy=name:ascending
  • Sort descending by source name: /dataSources/providers/{providerId}/sources?sortBy=name:descending The default sort is by name in ascending order.
start
integer
false

0-based Offset of first object to return. Defaults to 0.

Header Parameters

NameTypeRequiredDescription
Accept-Item
string
false

The desired data source representation. If no Accept-Item header is present, the full representation of data sources are returned.

Allowed values:
application/vnd.sas.data.source+jsonapplication/vnd.sas.data.source.summary+json
Default:
application/vnd.sas.data.source+json

Responses

StatusMeaningDescription
200OK

The request succeeded.

Schema
400Bad Request

The request was invalid. Invalid requests occur in the following scenarios:

  • A negative start value is provided.
  • A negative limit value is provided.
  • An unsupported field is specified in the sortBy parameter.
  • An unsupported field is specified in the filter parameter.
  • An invalid filter parameter is provided.
Schema
404Not Found

No provider exists at the requested path.

Schema