Conversion of text value to Json

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

Parents Reply Children
No Data