ExecuteSqlRecord adding escape characters to the JSON in clob column when pulling it using JsonRecordSetWriter - how to avoid it

[#1]

I have a COLB column on a table which contains Json. when I pull it using ExecuteSQLRecord, it is adding Escape Characters to the Json.
How to avoid it adding escape Characters. 

[ {
"COLB_COLUMN" : "{\"requestId\":\"502\",\"systemId\":\"77734175-3c8b-471d-b683-8bee62e7b975\",\"responseData\":[]}"
} ]

Updating Media

I have also Tried using ExecuteSQL and convertAvroToJson still there are Escape Characters. 

[#2]

Hi @Anderosn ,

From previous posts it seems this is a common behavior for COLB column data type and it doesnt seem like you can avoid it. To extract the json value please refer to the following post: https://community.cloudera.com/t5/Support-Questions/Avro-to-Json-adding-extra-delemeters/m-p/380646#...