Transforming XML / Creating XML Files

Hi,

Is there a way to transform data into individual XML structure ?

For example - im getting a XML from a HTTP Request like

<ORDER>
<ORDER_INFO>
	<ORDER_HEADER>
		<ORDER_ID>2165912</ORDER_ID>
		<CUSTOMER_ID>107791</CUSTOMER_ID>
		<CUSTOMER_CID>179050</CUSTOMER_CID>
		<CUSTOMER_GROUP>5</CUSTOMER_GROUP>
		<ORDER_DATE>2021-07-07 11:59:02</ORDER_DATE>
		<ORDER_STATUS>17</ORDER_STATUS>
		<ORDER_IP></ORDER_IP>
		<ORDER_CURRENCY>EUR</ORDER_CURRENCY>
		<ORDER_CURRENCY_VALUE>1.0000</ORDER_CURRENCY_VALUE>
		<ORDER_SOURCE>shop</ORDER_SOURCE>
		<ORDER_SOURCE_ORDER_ID></ORDER_SOURCE_ORDER_ID>
	</ORDER_HEADER>
	<BILLING_ADDRESS>
		<VAT_ID></VAT_ID>
		<COMPANY></COMPANY>
		<FIRSTNAME>XXX</FIRSTNAME>
		<LASTNAME>XXX</LASTNAME>
		<STREET>XXXXX-XXXXX-Str.11</STREET>
		<POSTCODE>234324</POSTCODE>
		<CITY>XXXXX</CITY>
		<SUBURB></SUBURB>
		<COUNTRY>DE</COUNTRY>
		<TELEPHONE></TELEPHONE>
		<EMAIL>[email protected]</EMAIL>
		<GENDER></GENDER>
	</BILLING_ADDRESS>

out of this i want to generate a different XML structure and push it to an FTP

<ROOT>
<ORDER>
	<Status>I</Status>
	<Bestellnummer>2165909</Bestellnummer>
	<PaymentStatus>on-hold</PaymentStatus>
	<PaymentType>Rechnung</PaymentType>
	<PaymentTotal>49.00</PaymentTotal>
	<ADRESS>
		<ShopID>20865</ShopID>
		<AdressTyp>1</AdressTyp>
		<Anrede>Frau</Anrede>
		<Vorname>XXXXX</Vorname>
		<Nachname>XXXXX</Nachname>
		<Strasse>XXXXX25</Strasse>
		<PLZ>123123123</PLZ>
		<Ort>XXXXXX</Ort>
		<Land>DE</Land>
		<Telefon>0000000</Telefon>
		<Preiskennung>1</Preiskennung>
		<Email>[email protected]</Email>
		<LIEFER/>
	</ADRESS>

is this somehow possible ?

Hey @mzfit24!

Welcome to the community :sparkling_heart:

Did you check the solution shared here: Need specific XML output? It might me useful for you :slight_smile:

hey.

thx for the welcome. yeah i saw that thread - but this was only for manipulating the same node.

would it also be possible to generate a complete different xml structure ?

Hey! Can you please explain what do you mean by this:

but this was only for manipulating the same node

You can take the same approach to convert the format. You can even use the Function node to transform the data.