Check row set availability

head/sessions/{sessionId}/data/{libref}/{tableName}/rowSet
Internal-Use Only

Determines whether a row set is available on for a data set.

Request Samples

1

Response Samples

1No example avaliable

Path Parameters

NameTypeRequiredDescription
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.

Query Parameters

NameTypeRequiredDescription
columnDetail
string
false

Specifies the level of column information to return.

Allowed values:
namesdetailsummary
Default:
names
columnNaturalOrder
boolean
false

When includeColumns is specified, a value of true for columnNaturalOrder specifies that the cells of the row set are returned in the order in which they occur in the data set instead of in the order that is specified by includeColumns.

Default:
false
format
boolean
false

Specifies whether to format the data in the cells.

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.

includeColumns
string
false

Specifies a comma separated list of columns to include in the row set. If you do not specify a list, all columns are returned. The order of the column names in the list is the order in which the cells of the row set are in as well.

limit
integer
false

Specifies the maximum number of rows to return. The default value is "10".

returnNumAsString
boolean
false

If set to true, SAS numeric values found in the data will be returned as strings.

Default:
false
sortBy
string<sort-criteria>
false

Sets the sort order for the returned row set.

start
integer
false

Specifies the offset of the first row to return. The default value is "0".

where
string
false

Specifies that a standard SAS WHERE clause was used to build the row set for this request.

Responses

StatusMeaningDescription
200OKThe request succeeded.Headers
404Not FoundNo resource exists at the requested path.