Appsheet and Smartsheet Integration issue

AppSheet AppSheet Q&A
1

The current application D360 Appsheet architecture utilizes a hybrid data sourcing model: Data Sources: Google Sheets. and Smartsheet (specifically the Projects table).

While editing data in AppSheet and attempting to save, the system failed to synchronize with the Smartsheet provider. Error Message: “Errors”: “Unable to update row in table ‘Projects’. → A task was canceled.” Attached the error screenshot

3d5YQTN9EeVfr8x
3d5YQTN9EeVfr8x1917×915 123 KB

A new, more persistent error has emerged when users attempt to create new projects.Error Message: : “Error: AppSheet Workflow Failed: Error 4000 in SmartsheetProvider retry: An unexpected error has occurred. Please contact the Support team”

6JWYNMMG9hYpHmd
6JWYNMMG9hYpHmd2286×883 153 KB

2

Hi, I encountered the same error about 10 hours ago. I reported it to the support team, and during exhaustive testing, we obtained the same result: we couldn’t create, update, or delete rows in Smartsheet. I just ran another test, and it seems to be working now, but I’m not ready to consider the problem solved. I’ll continue testing.

image
image565×593 35.3 KB

3

Yes, the issue has been resolved automatically. However, it occurs intermittently and has happened multiple times previous week also.

Contacted both Appsheet and Smartsheet support team, they mention like will check with Specialist team and get back to us.

4

This is part of complex integration. A failure, even a transient one, in any of the integrated service providers can break the entire app.

In the app editor, review the options available in the Monitor page:

image
image1553×1003 62.5 KB

5

Thank you for your interest. I just ran the Audit History and here is the error message for the failed actions:

Error:
“System.NullReferenceException: Object reference not set to an instance of an object.\n at Smartsheet.Api.Internal.Http.DefaultHttpClient.ShouldRetry(Int32 previousAttempts, Int64 totalElapsedTime, HttpResponse response)\n at Smartsheet.Api.Internal.Http.DefaultHttpClient.Request(HttpRequest smartsheetRequest)\n at Smartsheet.Api.Internal.AbstractResources.PutAndReceiveList[T,S](String path, T objectToPut, Type objectClassToReceive)\n at Smartsheet.Api.Internal.SheetRowResourcesImpl.UpdateRows(Int64 sheetId, IEnumerable`1 rows)\n at SmartSheet.SmartsheetTable.UpdateStandardRow(SmartsheetRow row) in /src/Provider/SmartSheet/SmartsheetData/SmartsheetTable.cs:line 345\n at SmartSheet.SmartsheetTable.UpdateRowsAsync(Context context, Op op, ImmutableArray`1 rows, ImmutableArray`1 colTypes, CancellationToken cancellationToken) in /src/Provider/SmartSheet/SmartsheetData/SmartsheetTable.cs:line 323\n at ProviderBase.ExternalApiProviderData.UpdateRowsAsync(Context context, Op op, PhysicalSchema physicalSchema, ImmutableArray`1 colTypes, List`1 keyPositions, Int32[] columnSliceMapping, List`1 changedRowKeyPositions, CancellationToken cancellationToken)\n at ProviderBase.APIBasedProvider.UpdateTableRowsAsync(Context context, Op op, String name, Int32 ownerId, TokenId tokenId, PhysicalSchema physicalSchema, DataFormat fileFormat, ImmutableArray`1 colTypes, List`1 keyPositions, Int32[] columnSliceMapping, List`1 changedRowKeyPositions, CancellationToken cancellationToken) in /src/Provider/ProviderBase/ApiBasedProvider/APIBasedProvider.cs:line 321\n at LegacyDataLayer.LegacyAppTemplateDataLayer.UpdateTableRowsAsync(Context context, Op op, Int32 ownerId, AppTable appTable, ImmutableArray`1 colTypes, List`1 keyPositions, Int32[] columnSliceMapping, List`1 changedRowKeyPositions, CancellationToken cancellationToken) in /src/Data/LegacyDataLayer/LegacyAppTemplateDataLayer.cs:line 436\n at ActionEvaluator.RowOperationEvaluator.UpdateTableRowInternalAsync(Context context, Op op, Int32 userId, Int32 executeAs, CancellationToken cancellationToken) in /src/Automation/ActionEvaluator/RowOperationEvaluator.cs:line 1283\n at ActionEvaluator.RowOperationEvaluator.PerformOperationWithTimeout(Context context, Op op, Int32 userId, AppTemplate appTemplate, UpdateModeEnum requiredUpdateMode, RowOperationAsync rowOperation, CancellationToken cancellationToken) in /src/Automation/ActionEvaluator/RowOperationEvaluator.cs:line 465\n at ActionEvaluator.RowOperationEvaluator.PerformOperationAsync(Context context, Op op, Int32 userId, String appTemplateVersion, UpdateModeEnum requiredUpdateMode, RowOperationAsync rowOperation, CancellationToken cancellationToken) in /src/Automation/ActionEvaluator/RowOperationEvaluator.cs:line 283\n at ActionEvaluator.RowOperationEvaluator.UpdateTableRowAsync(Context context, Op op, Int32 userId, String appTemplateVersion, UserType userType, CancellationToken cancellationToken) in /src/Automation/ActionEvaluator/RowOperationEvaluator.cs:line 1165\n at ServerHandler.UpdateTableRowHandler.UpdateTableRowInternal(IPerfCollector perfCollector, Context context, Op op, String appTemplateVersion, IQueryString queryString, CancellationToken cancellationToken) in /src/ControllerHandler/ServerHandler/UpdateTableRowHandler.cs:line 231”

6

This is typical of an internal error. It can only be diagnosed by someone within AppSheet, which means you must go through Support.