Create file XML with multiple invoices from Salesforce

[Jean1636577440]

Hello to all, 

I would like to extract several invoices from Salesforce and add them in an XML file that would group all these invoices.

An invoice is composed of a header, lines and a footer.

The expected result in XML is the following :

I used tAdvancedFileOutputXML as output by checking the append option, but I can't reproduce the above result.

I thank you in advance for your help and answers.

[Anonymous]

Hello @Venom sorrow​ ,

You can use loop/group function by tAdvancedFileOutputXML to generate the xml you expected

please refer to the below article

https://help.talend.com/r/en-US/8.0/xml-connectors/tadvancedfileoutputxml-tfileinputdelimited-creating-xml-file-using-loop-standard-component-the

Best regards

Aiming

[Jean1636577440]

Hello, I managed to get this result with the tAdvancedFileOuputXML component.

However I still have a problem with one of the XML nodes.

The tAdvancedFileOuputXML requires us to create a parent tag to create a loop and a group.

I would like to have this result without the parent tag Lines

:

Currently, I am forced to wrap these nodes in a Lines tag, I would like to remove this Lines tag :

Thank you for your help.