Return a proper error message from SQL Server database and show to the users

[mahsa_sadat]

Hi everyone

We use Appsheet to create our Apps, OData API as middleware, and Microsoft SQL Server as a data source.

Now when users sync the changes, if anything goes wrong, they see a common error message saying: ‘Unable to add/edit/delete row in table ‘TableName’. → OData web request error (InternalServerError) System.Exception: OData web request error’

I’d like to know if there is any way that I can provide a proper/related error message from SQL server and send it back to the Appsheet by Middleware that let the users see that error message instead of the common one.

Thank you so much

[Steve]

Not possible.