Conversion of text value to Json

Question

Hi All, 
 I have a requirement like. 
 1. An external system will update the message into a table in Appian. 
 2. The structure will be resemble something like this. 
 { "H16":{}, "H7":{}, "T02":{ "T02_06":{ "T02_06_01":{} }, "T02_05":{}, } } 
 3.I need to fetch this data from Table and convert into Json format. 
 
 Issue i am facing: when i am fetching from Mysql DB it is adding  and 
 into my message. post that when i am using a!tojson it is giving me an error that passed text but to convert to json it needs a cdt or list. 
 Can someone suggest how to convert into json structure. 
 
 Please Note that my Message body might contain data of 30 K lines and 300 to 400 parameters.

Chanakya Volam · Answer

When external system is writing to DB in JSON format, why not use the data type in DB as JSON instead of text or varchar. If the datatype is JSON in table you dont need to worry about converting in appian again. 
 
 You can map JSON table column to text type in appian CDT

davel001150 · Answer

You could also try BLOB or CLOB datatype. 
 You could also create a rule to replace  and 
 with the appropriate Unicode for newlines and carriage returns using the char() function.