How to empty a sheet with 8000 rows

LudoWipple

Hello,

We have a big excel file that we need to auto update on smartsheet. For that, I use the node js API and it's working well.

I run this each night. At one moment, it can't run because the sheet is full ( max row is reached ) so I need to empty the sheet before sending new data.

I need to keep the same ID of sheet, so I can't just delete it and create a new. Or deplace row to another sheet, because at one moment the "trash" sheet will be full too. I really need to empty the sheet like you do in the web interface by selecting all, right click and delete.

I tryed to usehttps://smartsheet.redoc.ly/tag/rows#operation/delete-rowsbut it don't work because there is too much rows and I get a timeout, or it's a very long action ( more than 2 hours ) and fail at one moment. I searched for third party app like Zapier but no one can empty a sheet.

So my question is, is there a way to empty a sheet ?

Thanks,

Andrée Starå

Hi@LudoWipple

I hope you're well and safe!

Have you explored using the Premium App, Data Shuttle?

Is that an option?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

What if you broke it down to run the delete rows portion on only 500 rows at a time over and over again until the sheet was empty?

LudoWipple

What if you broke it down to run the delete rows portion on only 500 rows at a time over and over again until the sheet was empty?<\/p>","bodyRaw":"[{\"insert\":\"What if you broke it down to run the delete rows portion on only 500 rows at a time over and over again until the sheet was empty?\\n\"}]","format":"rich","dateInserted":"2023-05-17T12:01:36+00:00","insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-28T18:51:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/376171#Comment_376171","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/376171#Comment_376171

The

https://smartsheet.redoc.ly/tag/rows#operation/delete-rows

Can be used by max batch of 500 ? I couldn't do it like that. I could do it line by line but it's way too long.

Do you have a simple example in node.js that can help me ?

Thanks

Danielle Wilson

@LudoWippleI agreeData Shuttlewould be the simplest way to both load in the data from another source and to clear out your sheet at the same time (it could just totally replace everything in the sheet).

作为另一个选择如果你想没有擦out all the data every day but instead to keep a full record base, you could look intoDataTableas this is designed to handle larger datasets than sheets.