Try putting quotes around the json string when using in code:
insert into table1 (jsonscript) values ("{'data': '{'Code': 'MXXXXX', 'Status': 'failed'}'}")
Also make sure you either escape your double quotes if you have them in the string :
"{\"data\": \"{\"Code\": \"MXXXXX\", \"Status\": \"failed\"}\"}"