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 \r and \n 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.
Discussion posts and replies are publicly visible
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
You could also try BLOB or CLOB datatype.
You could also create a rule to replace \r and \n with the appropriate Unicode for newlines and carriage returns using the char() function.