Based on requirement I need to pass the Parent and Child name as parameter, and it will invoke all the child(recursively) till leaf node and generate the xml.The node above parent node won't come in the output xml file.
Now if I pass Project as parent and Client Project as child.It will invoke
Project --> Client Project --> Project Details --> Manager --> Employee Details branch.
Now if I pass Project as parent and Internal Project as child.It will invoke
Project --> Internal Project --> Project Details --> Manager --> Employee Details branch.
Either way if I pass pass company as parent and project as child. It will invoke all the information related to client project as well as internal project.
I am to pass those parameter in run time and it will create xml file accordingly.
We have developed Talend jobs for loading data from Rest API to Flat files , which were being picked up by a framework to load it into Database. Sample entities are Booking, Task, Customer etc.
1. The response from the API is in XML format, so for each and every entity we have developed a Talend job to read the response from the API and write it into a flat file which is feasible for loading into database. 2. To Describe more, we used tRest--> tExtractXMLField-->tMap-->tFileoutputdelimeted
1. The tRest component will be unique for each object, which includes input parameters defined for each entity, the response will be picked using tExtractXMLField to extract each xml node and mapping to a flat file doing transformations. 2. Here the XML tree is defined for each and every entity in separate talend jobs. 3. What we are looking to do is, we need to place those input xml tree columns in a csv file with entity name as filename, and it should load the file run time and as per the entity specific it should create xml mapping dynamically and after handling transformations using tmap, the file is generated . This is what we are looking for.
