TO API should not try to insert any non-integer into an integer DB column

[mitchell852]

All create/update api endpoints need to validate that non-integers (i.e. empty strings) are not passed in where integers / numbers are expected in the database.

Need better API validation to catch these and return a 400 Bad Request with a message.