REST API: How to get error details of Field Validation errors, SPListDataValidationException

Question

I am using pnpjs to add items to a list like so:

this.spClient.web.lists.getByTitle(this.spList).items.add(requestList);

If requestList has items that do not pass column validation of the Sharepoint list I receive an exception with only a very generic error message:

{"odata.error": {
     "code": "-2130575163,Microsoft.SharePoint.SPListDataValidationException",
     "message": {
         "lang": "en-US",
         "value": "List data validation failed."
      }
}}

How can I retrieve the information which fields failed validation?

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest#working-with-list-items-by-using-rest suggests the information should be available and if I try to add such an erroneous element manually in Sharepoint itself the form marks the errors in red.

Answer 1

Go into the network tab in Chrome dev tools (or else use Fiddler), find the REST call and inspect the raw response from the server. For 400-type errors you'll typically see a more detailed description of the error.

Answer 2

You can add the item using PnPjs like this:

private PnPAddItem():void
{
  sp.web.lists.getByTitle("Jerry").items.add({
    Title: "NewItemAddedTitle"
  }).then((iar: ItemAddResult) => {
    console.log(iar);
});

}

You can console.log(iar) response in the console to see which field failed validation and you could also check the Network tab to see reponse status and request details: