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

Best way to automatically copy a Smartsheet file to a SharePoint List?
I've been looking on the internet for a good way to copy a Smartsheet to a SharePoint list. One of the recommendations was to user Datashuttle which I tried but it only creates a .csv or .xlsx file in the SharePoint library. What I need is for the SharePoint List to be updated automatically from the Smartsheet file so the…
Smartsheet API - Is it possible to create a copy of a sheet and maintain the row and column IDs?
Is it possible to use the Smartsheet API to create a new sheet from a copy of an existing sheet, but maintain the row and column IDs? Ideally the output would be 2 sheets with unique IDs, but the row and columns within each would have identical IDs
How can I obtain the URL for a form that is attached to a sheet ?
I need to obtain the FORM URL that is associated with a sheet that is copied via API so that I can populate the URL in a cell. I was reading over the API documentation and cannot seem to find where this is possible. I know this has been asked sporadically and apologies for the duplicate asks, but this seems like such a key…