Trying to delete a large number of rows trough API

I am using the Node JS SDK to delete the content from a sheet. It works fine but for a lot of rows it fails (I have tested with a minimun of 1000). I get an error that says that the request is to large for the server. I understand whats happening, but I was wondering if there is another way to clear a sheet using the API.

This is the error

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">\n<html><head>\n<title>414 Request-URI Too Large</title>\n</head><body>\n<h1>Request-URI Too Large</h1>\n<p>The requested URL's length exceeds the capacity\nlimit for this server.<br />\n</p>\n</body></html>

Find more posts tagged with

Construction

API and Developers

Project Management

Comments

dAVE Inden

The request to delete rows adds the row ids as query strings to the URL. Since row ids are 16 digits long if you provide 1000 row ids at once it will create a URL that is over 16,000 characters. Typically URLs that are this large will fail with this error due to too many characters.

I suggest breaking up your list into smaller chunks, ~100-200, and looping through it to send multiple delete requests to the sheet instead of sending them all at once. You may need to tweak the number of row ids to include to get as many deleted in one request.

geraldo16

The problem with this solution is that if I try to send several delete request to the API it will reply that there is a request to the same sheet been processed, so I need to figure out how to wait till the end of every request to start the other. I was looking an alternative using the API that alows me to clear the sheet or something like that.

dAVE Inden

Yes, with the looping process you would need to wait until you get a response back from the previous request before moving on to the next one to keep from getting that error.

geraldo16

The solution was that, breaking the total of rows in small pieces (200 rows per piece), and then passing the request, one by one. I had to wait for a request to end to send the next request. So i did a for cicle, and using await I turned the asyncronous behavior of javascripts into syncronus. Working great so far, I was even prepared for a decrease in performance but I tested this method with 5000 rows and worked fine and fast. Maybe in the future in would be great if we could delete several rows by passing an array of elements with the ids to delete, using a post method. Will be better in my opinion, and also similar for example to the process where you insert several rows.

Ian Macintosh

Any chance you could give us some sample code please? I have been battling the syntax for a day and just can't get my head around it :-(

Sign in to join the conversation!

Quick Links

Trending discussions

Does a view-only user need a license to use the API?
Hello everyone, I will need to use Smartsheet API to ingest data from Smartsheet to an object storage. To do that, my client will create a view only account for me. If I understand correctly, to use the API the account needs to be licensed, so we will need to pay for this "service account". That is correct?
Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…