Point me in the right direction - Troubleshooting API

Thanks @KevinFansler. I will take a look at those links, and see if I can review the actual API code for more information.

Any recommendations on a developer that works in .NET, SQL, and the Smartsheet API? In summary, our app is a .NET that queries Microsoft Dynamics SL (SQL database) for any changes since last query and creates a list of updates. It then uses the accounting ID (key) to find the sheet and then the row in Smartsheet, and updates it. If its a new entry, it creates a new row in the sheet. These errors started on 1/4/2024 if that makes any difference. I am not sure if the errors are on the SQL query side, or the Smartsheet API side, but guessing API side.

Currently, it is having two issues:

1. Its throwing errors on some row updates. I have confirmed that the rows do exist, and were not deleted. The rows it updated prior to this row are indeed updated. The row it throws the error on exists, but is not updated.
2. The updates it is completing are now preceded with an ', making them a text string instead of a number. So all the formulas in smartsheet associated with that row are not functioning.
   1. Note, all updates prior to 1/4, the cells were populated with numbers correctly... starting 1/4 and after, the cells that are updated have the correct number, but are preceded with a '.

In the meantime, I am reviewing the API files. I am not a developer, and not expecting free services here, but any advice appreciated. In follow the chain of errors in the log file:

1. [INF] Task Row is available for Accounting ID - 114011120608017 in Project (1695690821789572). Updating the Same Row
   1. Accounting ID is a key between the SQL data and Smartsheet. The Project # is the Smartsheet sheet ID.
2. [ERR] SS_ERR_09 - Error Updating or Inserting - An unexpected error has occurred.
3. [ERR]  at [this is followed by a list of errors and what I assume are library objects outlined below... again, not a developer]

In looking at the individual lib references I find:

Error at libs.SmartSheetConnect.UpdateRowsHandler(Int64 sheetId, List`1 rows) which references SmartSheetConnect.cs:line 175 which is in the following function ("Throw new exception" is row 175)

    private IList<Row> UpdateRowsHandler(long sheetId, List<Row> rows)
    {
      try
      {
        return client.SheetResources.RowResources.UpdateRows(sheetId, rows);
      }
      catch (Exception ex)
      {
        throw new CVLReportException("SS_ERR_09", "Error Updating or Inserting - " + ex.Message.ToString());
      }
    }

Error at SmartSheetConnect.InsertUpdateRows(SheetOps sheetOp, Int64 sheetId, List`1 rows) and references SmartSheetConnect.cs:line 124 which is in the following function (IList<Row> is line 124):

private List<Row> InsertUpdateRows(SheetOps sheetOp, long sheetId, List<Row> rows)
    {
      var result = new List<Row>(0);

      Func<long, List<Row>, IList<Row>> insertUpdateHandler = GetInsertUpdateRowsHandler(sheetOp);
      string actionName = sheetOp == SheetOps.InsertRows ? "Insert" : "Update";

      // Log.Debug($"{actionName}: {rows.Count} rows in sheet {sheetId}");

      // Set the initial counters.

      int rowCount = rows.Count;
      int handledCount = 0;

      // Handle the records in batches.
      for (int i = 0; i < rowCount; i += BatchCount)
      {
        var actionRows = rows.Skip(i).Take(BatchCount).ToList();
        // Log.Debug($"{actionName}: Rows {handledCount} - {handledCount + actionRows.Count}");

        IList<Row> actionResult = insertUpdateHandler(sheetId, actionRows);

        handledCount += actionResult.Count;
        result.AddRange(actionResult);
      }

      // Log.Debug($"{actionName}: {handledCount} rows in sheet {sheetId}");
      return result;
    }

Error at libs.SmartSheetConnect.UpdateRows(Int64 sheetId, List`1 rows) and references SmartSheetConnect.cs:line 101 which is in the following function:

public List<Row> UpdateRows(long sheetId, List<Row> rows)
    {
      return InsertUpdateRows(SheetOps.UpdateRows, sheetId, rows);
    }

Error at Services.CVLReportService.UpdateSmartSheet(List`1 CVLEarningReports) and references CVLReportService.cs:line 275 which is in the following function (List<Row> is line 275):

CVLEarningReport.accounting_id.ToString());

            Row row = new()
            {
              Id = updatedTaskRow.Id,
              Cells = FormTaskCells(accountingIDMatchRow, CVLEarningReport, subCategoryRow)
            };

            List<Row> updateResult = smartsheetManager.UpdateRows(projectSheet.Id.Value, new List<Row> { row });
            Log.Information($"Task Row for Accounting ID - {CVLEarningReport.accounting_id} updated successfully in Project

Error at Services.CVLReportService.Run() and references CVLReportService.cs:line 49 which is in the following function (return UpdateSmartsheet is line 49):

    public CVLReportService(IConfiguration _iconfiguration)
    {
      try
      {
        CVLReportService._iconfiguration = _iconfiguration;
        smartsheetManager = new(CVLReportService._iconfiguration);

        configSheet = smartsheetManager.GetConfigSheet();
        dbConnect = new(configSheet);
      }
      catch
      {
        throw;
      }
    }

    public TaskStatus Run()
    {
      try
      {
        return UpdateSmartSheet(RetriveData());
      }
      catch
      {
        throw;
      }
    }

and last, Error at Program.Main(String[] args) and references Program.cs:line 108 which is in (taskStatus = cvlReportService.Run() is row 108):

    public static void Main(string[] args)
    {
      TaskStatus taskStatus = new();
      JobStatus jobStatus = new();
      try
      {
        jobStatus.ID = $"job_{DateTimeOffset.Now.ToUnixTimeMilliseconds()}";
        jobStatus.StartTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
        InitConfigurations();

        CVLReportService cvlReportService = new(_iconfiguration);
        taskStatus = cvlReportService.Run();
      }
      catch (CVLReportException ex)
      {
        isExceptionThrown = true;
        Log.Error(ex.ErrorCode + " - " + ex.ErrorMessage);
        Log.Error(ex.StackTrace);
      }
      catch (Exception ex)
      {
        isExceptionThrown = true;
        Log.Error("APP_ERR_01 - Internal Server Error");
        Log.Error(ex.Message);
        Log.Error(ex.StackTrace);
      }
      finally
      {
        InsertJobStatus(taskStatus, jobStatus);
      }
    }