Click or drag to resize

SheetRowResources Methods

The SheetRowResources type exposes the following members.

Methods
  NameDescription
Public methodAddRows

Inserts one or more rows into the Sheet specified in the URL.

It mirrors to the following Smartsheet REST API method: POST /sheets/{sheetId}/rows

Remarks
If multiple rows are specified in the request, all rows must be inserted at the same location (i.e. the toTop, toBottom, parentId, siblingId, and above attributes must be the same for all rows in the request).
Public methodAddRowsAllowPartialSuccess

Inserts one or more rows into the Sheet specified in the URL with allowPartialSuccess.

It mirrors to the following Smartsheet REST API method: POST /sheets/{sheetId}/rows?allowPartialSuccess=true

Remarks
If multiple rows are specified in the request, all rows must be inserted at the same location (i.e. the toTop, toBottom, parentId, siblingId, and above attributes must be the same for all rows in the request).
Public methodCopyRowsToAnotherSheet

Copies Row(s) from the Sheet specified in the URL to (the bottom of) another sheet.

It mirrors to the following Smartsheet REST API method: POST /sheets/{sheetId}/rows/copy

Remarks
Up to 5,000 row IDs can be specified in the request, but if the total number of rows in the destination sheet after the copy exceeds the Smartsheet row limit, an error response will be returned.
Public methodDeleteRows

Deletes the Row specified in the URL.

It mirrors to the following Smartsheet REST API method: DELETE /sheets/{sheetId}/rows/{rowId}

Remarks
This operation will delete ALL child Rows of the specified Row.
Public methodGetRow

Gets the Row specified in the URL.

It mirrors to the following Smartsheet REST API method: GET /sheets/{sheetId}/rows/{rowId}

Public methodMoveRowsToAnotherSheet

Moves Row(s) from the Sheet specified in the URL to (the bottom of) another sheet.

It mirrors to the following Smartsheet REST API method: POST /sheets/{sheetId}/rows/copy

Remarks

Up to 5,000 row IDs can be specified in the request, but if the total number of rows in the destination sheet after the copy exceeds the Smartsheet row limit, an error response will be returned.

Any child rows of the rows specified in the request will also be moved. Parent-child relationships amongst rows will be preserved within the destination sheet.

Public methodSendRows

Sends one or more Rows via email.

It mirrors to the following Smartsheet REST API method: POST /sheets/{sheetId}/rows/emails

Public methodUpdateRows

Updates cell values in the specified row(s), expands/collapses the specified row(s), and/or modifies the position of specified rows (including indenting/outdenting).

It mirrors to the following Smartsheet REST API method: PUT /sheets/{sheetId}/rows

Remarks
If a row’s position is updated, all child rows are moved with the row.
Public methodUpdateRowsAllowPartialSuccess

Updates cell values in the specified row(s), expands/collapses the specified row(s), and/or modifies the position of specified rows (including indenting/outdenting).

It mirrors to the following Smartsheet REST API method: PUT /sheets/{sheetId}/rows?allowPartialSuccess=true

Remarks
If a row’s position is updated, all child rows are moved with the row.
Top
See Also