Delete all rows in Smartsheet using API call

Prateek93

Hey,



I have a fairly large Smartsheet of about 500 rows which I am accessing through an API call.

Is there a way to delete all rows in the sheet using DELETE API request without mentioning all the row ids separately? 

Shaine Greenwood

There isn't a way to delete rows without passing row IDs to DELETE—it's a required parameter: https://smartsheet-platform.github.io/api-docs/#delete-rows

You could instead perform a GET sheet: https://smartsheet-platform.github.io/api-docs/#get-sheet

The sheet object contains a comma separated list of Row IDs, you could then pass that list to DELETE.