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

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!