I don't expect you can help me without seeing the API code, but wondering if you can point me in the right direction.
We have an API that was developed by a Smartsheet provided consultant during onboarding of our enterprise plan. The API queries our accounting database, then updates rows in various (500+) sheets, using a common ID code between the accounting system and rows in the sheet. This API runs nightly.
The API has not run for the past week. When I browse through the error log it provides I find a few things:
- 2024-01-08 12:27:49.510 -07:00 [ERR] The 'Project Plan' row could not be found
- 2024-01-08 12:27:49.512 -07:00 [ERR] SS_ERR_08 - Row couldn't be found
The error codes it provides seem to be specific to this API. But I have determined that it is looking for a row with 'Project Plan' in the task name. It turns out our template has had that row renamed to 'Work Plan' since the API was written. However, this error does not seem to stop the API, and it continues on, successfully updating rows, until it hits this error (### are mine replacing specific sheet and row ID's):
- 2024-01-08 12:27:53.309 -07:00 [INF] Task Row is available for Accounting ID - ### in Project sheet ###. Updating the Same Row
- 2024-01-08 12:27:56.103 -07:00 [ERR] SS_ERR_09 - Error Updating or Inserting - An unexpected error has occurred. Please contact the Support team at https://help.smartsheet.com/contact for assistance.
This is followed by several lines referencing the API library, including:
- SmartSheetConnect.UpdateRowsHandler(Int64 sheetId, List`1 rows)
- SmartSheetConnect.InsertUpdateRows(SheetOps sheetOp, Int64 sheetId, List`1 rows)
- SmartSheetConnect.UpdateRows(Int64 sheetId, List`1 rows)
- UpdateSmartSheet(List`1 Reports)
- Services.ReportService.Run() i
- Program.Main(String[] args)
The API appears to be updating some rows, but inserting the numbers as text values (preceded by an '), which it did not used to do.
Smartsheet isn't supporting even though it was an API developer they provided... so we are likely to going to need someone. Again, I know you can't assist without seeing the code... this is not my area of expertise... But any suggestions... even if its "you need to hire this person" :)