Suggested or maximum payload size for Update Rows?

I've got a service that updates a sheet's rows with data from another source. It works fine on a sheet that has <5000 rows and around 19 columns, but I keep getting error 4002 whenever I'm trying the service with a sheet with >11000 rows. Is there a maximum number of row objects (and cell data) that is suggested to ensure that the request doesn't timeout due to size?

Answers

  • There is a maximum on the total size of a sheet ( column * rows) but nothing formally defined by Smartsheet.

    I would suggest to define your own limit and spread data on multiple sheets and then consolidate the data through a report.

  • It would be nice if we could get a formal number limit so that we can build that into our API calls to update cells.