Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
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.
