Does anyone have experience dealing with Error Code 4002 (Server timeout exceeded. Request has failed.), and has any ideas on how to handle it.
It seems to come up for me when i am trying to update larger sheets
I don't think I have seen this type of error except maybe when Smartsheet is having issues that end up appearing on the Status Board https://status.smartsheet.com/
Being an error from Smartsheet, you may be best to contact their API support directly.
However, since you mention this is occurring on a large sheet, I have a few questions/suggestions:
Thanks for your help Lee!
I am actually already splitting it by 400 rows at a time, you think that is too much?
The sheet itself is large because of a combination of columns and rows.
The sheet has some more complicated formulas...
I don't have anything else that would be updating this at the same time
I just looked through my code for the closest situation I have to yours. And I see that I was updating 400 rows at a time too. I have not seen these 4002 errors with my use case.
400 must be a number used in some sample code in the API docs or Stack Overflow?
I would suggest trying to reduce the number. I would try reducing it dramatically. Try decreasing by half (200), and then either increase or decrease by 100 depending on if it works or not. Repeat until you find a stable chunk size.
If there are still errors, I think I would try escalating this to Smartsheet API support.
Thanks Lee, will give it a try!
Side point related to this, I put in an idea to implement 'idempotency' in API requests.
Sometimes in these larger requests that takes a long time, we should be able to poll the server and see if it is completed (using a request ID etc.)
If you didn't yet please vote on it!
Hello everyone, I'm struggling with a method in Smartsheet API to add several rows to a sheet with Date Columns included. The point is compared with "update_rows" where it's working perfectly, when I try to use add_rows, the date format stays in ISO format and looks like this: Which is not the case with update_row where…
Does anyone have any experience with connecting between Smartsheet and Unanet?
We are using the smartsheet-python-sdk to insert rows into SmartSheets. For almost two years we have had this script running with no issue, but in the last week, SmartSheets has started to trim the leading zeros on fields that are all numeric. Nothing has changed in our sheet or in our script. Are others having this issue?…
©2024. All Rights Reserved Smartsheet Inc.