Sporatic Error, using the API.

Steven MSteven M
edited 12/09/19 in API & Developers
10/18/18 Edited 12/09/19

Hello Everyone. 

I have another weird error.    the spread sheet I am making is 35 columns across and 270 rows down.   I do batch updates exclusively.  And I also time my updates to the most updates are 160 a minute to not overload the Server(a 200 ms delay between updates).   

sometimes mid way through the updates Im getting 


  • Invoke-WebRequest : { "errorCode" : 1006, "message" : "Not Found", "refId" : "td1ey3p82fb4", "detail" : { "index" : 0, "rowId" : 7863688549951364 } }
  • At <REDACTED>\Powershell\Smartsheet\SSUpdate2.ps1:248 char:27
  • + ... esponse2  = Invoke-WebRequest -Uri https://api.smartsheet.com/2.0/she ...
  • +                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  •     + CategoryInfo          : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebException
  •     + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand    


But if I wait a second or 2, it runs through no problem. ???


Am I pumping too much data through?


any help would be appreciated. 


  • IanNIanN Employee

    Hello Steven M,

    From the sounds of it, there may be a row that is trying to be updated that may have been deleted. This will likely need some more troubleshooting. Please submit a ticket by emailing [email protected]sheet.com and we'll be happy to troubleshoot further. If you're willing, please include your Request as well as the Response body. The refID above will help us investigate too. 

    Kind Regards,


    Smartsheet Support

Sign In or Register to comment.