Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In Talend 5.3.1 ,
I am trying to output JSON but the format is Incorrect .
The input file is CVS .
The Excepted results are :-
{
"properties": [
{
"property": {
"reportdatefrom": "5/12/2016 2:31:29 PM",
"reportdateto": "12/31/9999 12:00:00 AM",
"entitycode": "1000750",
"propertyvalue": {
"jvalue": {
"eng": "bank",
"fra": "banque"
}
}
}
},
{
"property": {
"reportdatefrom": "5/12/2016 2:31:29 PM",
"reportdateto": "12/31/9999 12:00:00 AM",
"entitycode": "1000720",
"propertyvalue": {
"jvalue": {
"eng": "tissot",
"fra": "ploru"
}
}
}
},
{
"property": {
"reportdatefrom": "5/12/2016 2:31:29 PM",
"reportdateto": "12/31/9999 12:00:00 AM",
"entitycode": "1000760",
"propertyvalue": {
"jvalue": {
"eng": "can",
"fra": "Hugo"
}
}
}
}
]
}
But My output is
{"properties":[{"property":"{\"reportdatefrom\":\"5\/12\/2016 2:31:29 PM\",\"reportdateto\":\"12\/31\/9999 12:00:00 AM\",\"entitycode\":\"1000750\",\"propertyvalue\":{\"jvalue\":{\"eng\":\"bank\",\"fra\":\"banque\"}}}"},{"property":"{\"reportdatefrom\":\"5\/12\/2016 2:31:29 PM\",\"reportdateto\":\"12\/31\/9999 12:00:00 AM\",\"entitycode\":\"1000720\",\"propertyvalue\":{\"jvalue\":{\"eng\":\"tissot\",\"fra\":\"ploru\"}}}"},{"property":"{\"reportdatefrom\":\"5\/12\/2016 2:31:29 PM\",\"reportdateto\":\"12\/31\/9999 12:00:00 AM\",\"entitycode\":\"1000760\",\"propertyvalue\":{\"jvalue\":{\"eng\":\"can\",\"fra\":\"Hugo\"}}}"}]}