Get a collection of rows

get/tables/{tableId}/rows

Returns a collection of rows. Standard paging options are provided. Sorting and filtering options are provider dependent, but the default sort order is ascending by row order (for example, index). If the provider has naturally unordered row data, it must allow for pagination in a consistent manner.

Request Samples

1

Response Samples

1{
2  "name": "rows",
3  "accept": "application/vnd.sas.data.row",
4  "start": 0,
5  "limit": 10,
6  "items": [
7    {
8      "version": 1,
9      "cells": [
10        "Acura",
11        "MDX",
12        "SUV",
13        "$46,945",
14        "17",
15        "23"
16      ]
17    },
18    {
19      "version": 1,
20      "cells": [
21        "BMW",
22        "X3 3.0i",
23        "SUV",
24        "$47,000",
25        "16",
26        "24"
27      ]
28    },
29    {
30      "version": 1,
31      "cells": [
32        "Cadillac",
33        "CTS VVT 4dr",
34        "Sedan",
35        "$32,835",
36        "18",
37        "25"
38      ]
39    },
40    {
41      "version": 1,
42      "cells": [
43        "Dodge",
44        "Neon SE 4dr",
45        "Sedan",
46        "$18,670",
47        "29",
48        "36"
49      ]
50    },
51    {
52      "version": 1,
53      "cells": [
54        "Ford",
55        "Focus",
56        "Sedan",
57        "$17,270",
58        "26",
59        "33"
60      ]
61    },
62    {
63      "version": 1,
64      "cells": [
65        "Honda",
66        "Civic Hybrid",
67        "Sedan",
68        "$22,140",
69        "36",
70        "51"
71      ]
72    },
73    {
74      "version": 1,
75      "cells": [
76        "Honda",
77        "CRV",
78        "SUV",
79        "$37,200",
80        "28",
81        "35"
82      ]
83    },
84    {
85      "version": 1,
86      "cells": [
87        "Toyota",
88        "Rav4 Hybrid",
89        "SUV",
90        "$36,945",
91        "36",
92        "42"
93      ]
94    },
95    {
96      "version": 1,
97      "cells": [
98        "Toyota",
99        "Prius",
100        "Hybrid",
101        "$26,500",
102        "45",
103        "57"
104      ]
105    },
106    {
107      "version": 1,
108      "cells": [
109        "Toyota",
110        "Highlander",
111        "SUV",
112        "$41,450",
113        "18",
114        "24"
115      ]
116    }
117  ],
118  "links": [
119    {
120      "method": "GET",
121      "rel": "collection",
122      "href": "/rowSets/tables/cas~fs~cas-shared-default~fs~MYCASLIB~fs~CARS/rows",
123      "uri": "/rowSets/tables/cas~fs~cas-shared-default~fs~MYCASLIB~fs~CARS/rows",
124      "type": "application/vnd.sas.collection",
125      "itemType": "application/vnd.sas.data.row"
126    },
127    {
128      "method": "GET",
129      "rel": "self",
130      "href": "/rowSets/tables/cas~fs~cas-shared-default~fs~MYCASLIB~fs~CARS/rows?start=0&limit=10",
131      "uri": "/rowSets/tables/cas~fs~cas-shared-default~fs~MYCASLIB~fs~CARS/rows?start=0&limit=10",
132      "type": "application/vnd.sas.collection",
133      "itemType": "application/vnd.sas.data.row"
134    },
135    {
136      "method": "GET",
137      "rel": "up",
138      "href": "/dataTables/dataSources/cas~fs~cas-shared-default~fs~MYCASLIB/tables/CARS",
139      "uri": "/dataTables/dataSources/cas~fs~cas-shared-default~fs~MYCASLIB/tables/CARS",
140      "type": "application/vnd.sas.data.table"
141    }
142  ]
143}

Path Parameters

NameTypeRequiredDescription
tableId
string
true

The ID of the table. Its format is 'providerIdfssourceIdfslibraryNamefstableName'. 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 list of available libraries.
  • tableName: name of the table. Use GET /dataTables/dataSources/{dataSourceId}/tables to see the list of available tables in a library. An example tableId for cas is 'casfscas-shared-defaultfsmodelsfscars'. An example tableId for Compute is 'Computefs97751fe6-8313-487f-865a-f941c8a75f8ffscat-compfscars'.

Query Parameters

NameTypeRequiredDescription
excludeItemLinks
boolean
false

Use this parameter to exclude the links from this collection's items. Defaults to true.

format
boolean
false

Use this parameter to format the cells of data. Defaults to true.

includeIndex
boolean
false

Use this parameter to include the row index as the first item in the row data. Defaults to false.

limit
integer<int32>
false

Pagination parameter, which specifies how many items to return.

Default:
10
preserveSession
boolean
false

This string has effect only if the sessionId query parameter is not specified. If this is set to true, and no sessionId is provided, the session created by the data service provider will not be destroyed. All returned links, except the "self" link, will have the sessionId query parameter added to their respective URIs. Also, they will 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 will be destroyed after the request is complete. Defaults to false.

sessionId
string
false

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

sortBy
string<sort-criteria>
false

The sorting criteria for the returned rows of data. The rows can be sorted by any valid column name. The default sort order is ascending by row order (i.e. index). Examples:

  • Sort ascending by column with id COLUMN_A: /rowSets/tables/{tableId}/rows?sortBy=COLUMN_A:ascending
  • Sort descending by column with id COLUMN_A: /rowSets/tables/{tableId}/rows?sortBy=COLUMN_A:descending
start
integer<int32>
false

Pagination parameter, which specifies the starting index.

Default:
0
where
string
false

The WHERE clause to pass through to the underlying data service. This parameter acts as a filter on the provided data. Example: ?where=Make='Honda'

Responses

StatusMeaningDescription
200OK

The request succeeded.

Schema
400Bad Request

The request was invalid. The error might occur in one of the following scenarios:

  • A negative start value is provided.
  • A negative limit value is provided.
  • A non-existent column is specified in the sortBy parameter.
  • A non-existent resource member is specified in the excludeItemFields parameter.
Schema
404Not Found

No resource exists at the requested path. The table that is associated with these rows does not exist.

Schema