Updating invoice notes 32134

[JonBendtsen]

FIX #32134 Updating Invoice Notes
throw RestException(500) if update of invoice fails

[JonBendtsen]

replaced with #32190

[natalieboucher]

In the new version 20.0.3 it still does not work.

If you extract an invoice with GET /invoices/{id} and the resulting JSON is returned with a PUT /invoices/{id} the system returns a 500 error.

{
"error": {
"code": 500,
"message": "Internal Server Error: Error Cannot add or update a child row: a foreign key constraint fails (XXXXXX.llxpn_facture, CONSTRAINT fk_facture_fk_facture_source FOREIGN KEY (fk_facture_source) REFERENCES llxpn_facture (rowid))"
},
"debug": {
"source": "api_invoices.class.php:699 at call stage",
"stages": {
"success": [
"get",
"route",
"negotiate",
"authenticate",
"validate"
],
"failure": [
"call",
"message"
]
}
}
}
If we remove “”fk_project": null, from the JSON everything works correctly including the private and public notes.
It would be appreciated if you could fix these corrections.

Thank you

[hregis]

@natalieboucher try with "fk_projet" (real name of field in database) instead "fk_project"
@eldy maybe adding a "synonym" parameter in "$fields" array in order to be able to determine the name of the field used if it is different from the name in the database ? (eg id/rowid, fk_soc/socid, etc...)