Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Manage Smartsheet → Delete Rows (Line Item Supported)
AI-generatedOverview
This node operation allows users to delete rows from a specified Smartsheet sheet by providing a comma-separated list of row IDs. It is useful for managing and cleaning up data within Smartsheet sheets by removing unwanted or obsolete rows.
Use Case Examples
- Deleting multiple rows from a project tracking sheet by specifying their row IDs.
- Automating the removal of completed tasks from a task management sheet.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | The identifier of the Smartsheet sheet from which rows will be deleted. Users can select from a list or specify an ID using an expression. |
| Row IDs (Comma-Separated IDs) | A comma-separated string of row IDs that specifies which rows to delete from the selected sheet. |
Output
JSON
result- The result of the delete operation, typically indicating success or failure of the row deletion request.
Dependencies
- Requires an API key credential for Smartsheet API access.
Troubleshooting
- Error 'No rows specified' occurs if the 'Row IDs' input is empty or missing. Ensure that the row IDs are provided.
- API errors related to invalid sheet ID or row IDs may occur if the specified sheet or rows do not exist or the user lacks permissions.
- Network or authentication errors may occur if the Smartsheet API credentials are invalid or expired.
Links
- Smartsheet API Documentation - Official API documentation for Smartsheet, useful for understanding the delete rows endpoint.