Parsing a JSON string from a Custom object field in email hiI have followed the same steps, but still no luck in parsing the JSON from my Custom Object.My Custom Object field (Field Name: RData) has data like below RData field has data as below [
{
"StuLast": "Abram",
"StuFirst": "Easton",
"Program": "UGD",
"Subject": "MUSC",
"Catalog": "10A",
"Section": 90
},
{
"StuLast": "StuLast2",
"StuFirst": "StuFirst2",
"Program": "UGD",
"Subject": "Chemistry",
"Catalog": "20B",
"Section": 65
}
] When I tried the following code in the Token to parse, I am getting an empty string #set($data = ${registrar_cList.get(0).rData})
#if($data.isEmpty())
#set($data='{}')
#end
#set($parsedJson = '#set($parsedJson='+ $data+')')
#evaluate($parsedJson)
$parsedJson['subject'] Note: I did upload the csv file into Marketo as UTF-8 format when updating the Custom object. My Goal is to display data from this Custom object field in an email.Any help is appreciated.
