Get row information
Returns the rows for a specified data set. By default, a collection is returned, and standard paging options are available.
1{2 "accept": "application/vnd.sas.compute.data.table.row",3 "count": 49858,4 "items": [5 {6 "cells": [7 "AF-0101 ",8 "AF-01 ",9 1,10 " 0.020917256889",11 " 0.011839722373",12 69.136845,13 34.603907,14 1,15 4,16 017 ]18 },19 {20 "cells": [21 "AF-0101 ",22 "AF-01 ",23 1,24 " 0.021222359985",25 " 0.011868170604",26 69.158125,27 34.605286,28 0,29 0,30 031 ]32 },33 {34 "cells": [35 "AF-0101 ",36 "AF-01 ",37 1,38 " 0.021485525757",39 " 0.011762109322",40 69.176348,41 34.598996,42 1,43 5,44 045 ]46 }47 ],48 "limit": 3,49 "links": [50 {51 "href": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/rows?start=0&limit=3",52 "itemType": "application/vnd.sas.compute.data.table.row",53 "method": "GET",54 "rel": "self",55 "type": "application/vnd.sas.collection",56 "uri": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/rows?start=0&limit=3"57 },58 {59 "href": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/rows",60 "itemType": "application/vnd.sas.compute.data.table.row",61 "method": "GET",62 "rel": "collection",63 "type": "application/vnd.sas.collection",64 "uri": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/rows"65 },66 {67 "href": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/rows?start=3&limit=3",68 "itemType": "application/vnd.sas.compute.data.table.row",69 "method": "GET",70 "rel": "next",71 "type": "application/vnd.sas.collection",72 "uri": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/rows?start=3&limit=3"73 },74 {75 "href": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/rows?start=49855&limit=3",76 "itemType": "application/vnd.sas.compute.data.table.row",77 "method": "GET",78 "rel": "last",79 "type": "application/vnd.sas.collection",80 "uri": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/rows?start=49855&limit=3"81 }82 ],83 "name": "Table Rows",84 "start": 0,85 "version": 286}
| Name | Type | Required | Description |
|---|---|---|---|
libref | string<object-id> | true | Specifies the libref for the request. |
sessionId | string<object-id> | true | Specifies the ID of the session. |
tableName | string<object-id> | true | Specifies the table or data set to query. |
| Name | Type | Required | Description |
|---|---|---|---|
format | boolean | false | Specifies whether to format the data in the cells. When false, decimal values are formatted based on the value of SAS Option DECIMALCONV. If more accuracy and better precision with more significant digits is desired, then set DECIMALECONV=STDIEEE. This SAS Option can be configured within a context's or a session's environment options. The session's environment options can be specified when the session is created or while the session is running using the updateOptionValue endpoint. Default: true |
formatMissingValues | boolean | false | If set to true, SAS missing values found in the data will be formatted based on the setting of the SAS Option MISSING. Otherwise, a NULL value will be returned. |
includeColumnNames | boolean | false | Specifies whether the first row that is returned consists of column names. |
includeIndex | boolean | false | Specifies whether the first value in the cell is the index of the requested row. Support for this parameter was added in version 2. Default: false |
limit | integer | false | Specifies the maximum number of rows to return. Default: 100 |
returnNumAsString | boolean | false | If set to true, SAS numeric values found in the data will be returned as strings. Default: false |
start | integer | false | Specifies the offset of the first row to return. Default: 0 |
where | string | false | Specifies that a standard SAS WHERE clause is used to return the rows for this request. When a WHERE clause is specified, the "count" attribute is omitted from the response because the exact number of rows is not known until the data is fully processed. This might take multiple requests due to response size limits and pagination. |