See: newQueryTableRows smart constructor.

Create a value of QueryTableRows with all optional fields omitted.

Use generic-lens or optics to modify other optional fields.

The following record fields are available, with the corresponding lenses provided for backwards compatibility:

$sel:maxResults:QueryTableRows', queryTableRows_maxResults - The maximum number of rows to return in each page of the results.

QueryTableRows, queryTableRows_nextToken - This parameter is optional. If a nextToken is not specified, the API returns the first page of data.

Pagination tokens expire after 1 hour. If you use a token that was returned more than an hour back, the API will throw ValidationException.

$sel:workbookId:QueryTableRows', queryTableRows_workbookId - The ID of the workbook whose table rows are being queried.

If a workbook with the specified id could not be found, this API throws ResourceNotFoundException.

QueryTableRows, queryTableRows_tableId - The ID of the table whose rows are being queried.

If a table with the specified id could not be found, this API throws ResourceNotFoundException.

$sel:filterFormula:QueryTableRows', queryTableRows_filterFormula - An object that represents a filter formula along with the id of the context row under which the filter function needs to evaluate.

The maximum number of rows to return in each page of the results.

This parameter is optional. If a nextToken is not specified, the API returns the first page of data.

Pagination tokens expire after 1 hour. If you use a token that was returned more than an hour back, the API will throw ValidationException.

The ID of the workbook whose table rows are being queried.

If a workbook with the specified id could not be found, this API throws ResourceNotFoundException.

The ID of the table whose rows are being queried.

If a table with the specified id could not be found, this API throws ResourceNotFoundException.

An object that represents a filter formula along with the id of the context row under which the filter function needs to evaluate.

See: newQueryTableRowsResponse smart constructor.

Create a value of QueryTableRowsResponse with all optional fields omitted.

Use generic-lens or optics to modify other optional fields.

The following record fields are available, with the corresponding lenses provided for backwards compatibility:

QueryTableRows, queryTableRowsResponse_nextToken - Provides the pagination token to load the next page if there are more results matching the request. If a pagination token is not present in the response, it means that all data matching the request has been loaded.

$sel:httpStatus:QueryTableRowsResponse', queryTableRowsResponse_httpStatus - The response's http status code.

$sel:columnIds:QueryTableRowsResponse', queryTableRowsResponse_columnIds - The list of columns in the table whose row data is returned in the result.

QueryTableRowsResponse, queryTableRowsResponse_rows - The list of rows in the table that match the query filter.

$sel:workbookCursor:QueryTableRowsResponse', queryTableRowsResponse_workbookCursor - Indicates the cursor of the workbook at which the data returned by this request is read. Workbook cursor keeps increasing with every update and the increments are not sequential.

Provides the pagination token to load the next page if there are more results matching the request. If a pagination token is not present in the response, it means that all data matching the request has been loaded.

The response's http status code.

The list of columns in the table whose row data is returned in the result.

The list of rows in the table that match the query filter.

Indicates the cursor of the workbook at which the data returned by this request is read. Workbook cursor keeps increasing with every update and the increments are not sequential.