API 2.0 performance

Pavel Bogatyrev

Pavel Bogatyrev ✭✭

05/17/20 in API & Developers

I have a large sheet 11K rows x 14 columns, it is smaller than maximim size

https://help.smartsheet.com/articles/506775-system-requirements-for-using-smartsheet#filesize

Using Java or Python API update for a single cell takes 5-11 seconds

with only 1-100 rows x 14 columns the same update takes only 600ms

Why performance is not constant?

Pavel.

0 ·

Categories

Trending in API & Developers

Smartsheet Error when trying to Publish a dashboard
I got an error when trying to publish a dashboard to use it as an embedded link (iframe). I have tried exiting and reloading Smartsheets, restarting my laptop and changing the permissions so i am the only admin/owner and it still gives me the same error. Please help, thank you. Error: "We ran into an error. Please refresh…
Is it possible to add child rows to multiple parent rows with a single API call?
I am attempting automate adding standard sub/child tasks to many parent tasks at the same time. Following the API documentation Specify-Row-Location I am using the parentID + toBottom location attributes for every child row. I am consistently getting errorCode 1123 when the program moves from the first parent row to the…
Get login activity for external users —equivalent to the User Type Report
What's the appropriate method I can use to return the equivalent to the User Type Report that one downloads in User Management? Basically what I want to retrieve is the following info: Email, Highest permission given on assets, Last activity, and Number of asset views by user. With the List Users method I can return the…