Configurable validations for json data in MySQL, .net core

Question

Hi, I am working on an assignment in .net core to build the logic so that validations for incoming json data to be made configurable in MySQL. The validations are very basic i.e. check value for json element null or not, checking json element is valid number or not etc. And update error message column if any. Please suggest a working to be solution for this. Thanks in advance.