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 was used to return the rows for this request. |