parseJSON works during dataprep, but produces error during analysis and refresh

[RobHendriks]

Thank you for sharing this question.

Please review this previous thread, it appears to be similar in nature to the issue described in your post.

parseJSON question

Hi Everyone, I wonder could anyone assist please: I am trying to parse this chunk of JSON in a calc field and am getting Syntax Errors: [{“content” : “19”, “chosen” : true, “is_correct” : true}, {“content” : “18”, “chosen” : false, “is_correct” : false}, {“content” : “20”, “chosen” : false, “is_correct” : false}, {“content” : “15”, “chosen” : false, “is_correct” : false}] The above is in a field called ‘answers’ (String field from direct query to postgres) I’ve tried several ways includin…