topic Create file XML with multiple invoices from Salesforce in Talend Studio

Create file XML with multiple invoices from Salesforce

Jean1636577440 — Fri, 15 Nov 2024 21:49:20 GMT

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 — Thu, 11 May 2023 07:48:35 GMT

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 — Mon, 15 May 2023 18:01:21 GMT

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.