Suggested or maximum payload size for Update Rows?

03/23/21
Answered - Pending Review

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.

Sign In or Register to comment.