JSON, TDM and MongoDB input and output w/o loosing nested hierarchies

One Star

JSON, TDM and MongoDB input and output w/o loosing nested hierarchies

I would like to be able to process MongoDB (JSON) hierarchies in and out out Talend Integration & Mapping perspectives without loosing nested hierarchies.
The mapping perspective works fine with JSON but how do I get nested loops in and out of TDM in a integration Job.
The problem is not so much moving things at the top of the hierarchy at a field level but more how JSON is defined as both input and output in the DI metadata. I don't think nested looping is possible.
This may be possible today and I might be miss-using components or we have to consider how effective we will be in the MongoDB area without these capabilities. 
It would be nice to treat JSON hierarchies more like we treat XML. Leave them intact and maybe even have a TJSONMAP component and then move at the field level leaving all hierarchies intact.
Community Manager

Re: JSON, TDM and MongoDB input and output w/o loosing nested hierarchies

Hi 
Can tExtractJsonFields fit the need? which can be used to extract data from a json string after you read the nested loop as a node. 
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business