REST API Add fails on table — internal AsdbTable exception, UI Add works fine

AppSheet AppSheet Q&A
1

I’m hitting a consistent server-side error when using the REST API (v2) Add action on the “Service Request” table in my app, while the identical Add works fine when performed manually through the app UI.

Error returned:
{
“type”: " RFC 9110 - HTTP Semantics ",
“title”: “Bad Request”,
“status”: 400,
“detail”: “Invalid request provided to AppSheet database”,
“traceId”: “00-f20bec49944310913a0b62bcd291d902-7989773f26fd4797-00”
}

Stack trace from a related failed request (from the app’s Automation/Audit log):
ExceptionHandlerFramework.CustomerFacingException: Invalid request provided to AppSheet database
at AsdbProvider.AsdbTable.InsertRowsInternalAsync(IEnumerable`1 rowValues, CancellationToken cancellationToken) in /src/Provider/AsdbProvider/AsdbTable.cs:line 659
at AsdbProvider.AsdbTable.InsertRowsAsync(…) in /src/Provider/AsdbProvider/AsdbTable.cs:line 608
at ProviderBase.ExternalApiProviderData.AppendRowsAsync(…) in /src/Provider/ProviderBase/ApiBasedProvider/ExternalApiProviderData.cs:line 258
at ProviderBase.APIBasedProvider.AppendTableRowsAsync(…) in /src/Provider/ProviderBase/ApiBasedProvider/APIBasedProvider.cs:line 262
at ActionEvaluator.RowOperationEvaluator.AppendTableRowsAsync(…) in /src/Automation/ActionEvaluator/RowOperationEvaluator.cs:line 1392
at ActionEvaluator.RowOperationEvaluator.AddTableRowInternalAsync(…) in /src/Automation/ActionEvaluator/RowOperationEvaluator.cs:line 819
at ActionEvaluator.RowOperationEvaluator.PerformOperationWithTimeout(…) in /src/Automation/ActionEvaluator/RowOperationEvaluator.cs:line 465
at ActionEvaluator.RowOperationEvaluator.PerformOperationAsync(…) in /src/Automation/ActionEvaluator/RowOperationEvaluator.cs:line 283
at ActionEvaluator.RowOperationEvaluator.AddTableRowAsync(…) in /src/Automation/ActionEvaluator/RowOperationEvaluator.cs:line 725
at RestApi.RestApiHandler.RestAdd(…) in /src/RestApi/RestApi/RestApiHandler.cs:line 382

Other trace IDs from repeated failed attempts, in case they’re useful for correlating logs:

  • 00-ec0b887134999702b2ff1a3cdc430c29-3ad4e62d2ba23593-00
  • 00-9cd68d5211f6d1c5dea5d7ad6475dac1-a2439d7d0a319d71-00
  • 00-109b8b3e0aa4b82244d47a8a3c2586eb-5f6da1fb7687cdc8-00
  • 00-0a720a00d9e40c282e3202c414eb4ac2-5109617d2ed5ad83-00
  • 00-b9d4306a30c990f63a0b62bcd291d4b4-de6f2d0a2be132bc-00
2

This is an internal error, so you’ll need to engage Support.

Note that AppSheet Database has numerous bugs and is not well supported. I strongly recommend using Google Sheets instead.

Attn @Jose_Arteaga