I have to disagree that it's all correct now: the error message, that's part of the question, is incorrect as it refers to malformed a json dataset - that you have since fixed. Copy and paste the SQL statement into SQL server and you'll get a different error message.