How to change XML structure

(0) Share

Report

Posted on by Jan_Ur

Hello,

as a newbie, i am struggling with this.

I have a xml file, that i need to change its structure from this:

to this:

as you can see, i need to go from each StoItem element having multiple atributes to have its own elements instead.

Hope I am using the correct terminology.

Any idea how to go about it?

Thanks for all suggestions.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Jan_Ur

It would be great if you provide sample data as text not as screenshot. Currently it is not possible to solve this puzzle because you provided input and output but not from the same source. You have to tell us which property should be transformed to which node if you change names.

For example. In your output-sample there is a node called "eshop". But there is no property called "eshop" in your input sample.

Or is this just a sample with no connection at all? In that case here is how I would do it. This is not 100% but maybe good enough for your need:

xml(json(replace(string(json(xml(YOURXMLDATA))), '"@', '"')))

Instead of YOURXMLDATA you have to put your xml data.

Was this reply helpful? Yes No
Jan_Ur 31 on at

Like (0)

Report

Hi, thanks for the reply.
Both sample data:

wrong format:
<Result DeaCurrency="CZK">
<StoItem Id="5011062" Code="TDE SHARK01" PartNo="SHARK01" EAN="8594161330141" Name="EVOLVEO Shark 35dBi, aktivní venkovní anténa DVB-T/T2" ManName="EVOLVEO" PriceDea="484.7100" PriceDeaCurrency="484.7100" QtyFree="50" Url="https://www.abacus.cz/default.asp?cls=stoitem&stiid=5011062" />
</Result>

right format:
<products date="05.08.2023:10:08" presna-dostupnost="N">
<product>
<eshop>Produkty značky solight.cz</eshop>
<objednaci_cislo>XA05</objednaci_cislo>
<EAN>8595092105587</EAN>
<MINQTY>2</MINQTY>
</products >

What I am really going for is the structure itself, not particular data.
I need to transform the "wrong formatted xml" from
<Result>
<StoItem
id=x
name = y
/>
</Result>
to
<Result>
<StoItem>
<id>x</id>
<name>y</name>
</StoItem>
</Result>

I hope I am explaining it better this time 🙂

Was this reply helpful? Yes No
Verified answer

Matthy79 4,180 Super User 2024 Season 1 on at

Like (1)

Report

Have you even tried my suggestion?

Was this reply helpful? Yes No
Jan_Ur 31 on at

Like (0)

Report

have not 😄 i was just so excited to answer that i didnt even think about trying it, since i wasnt sure about the explanation.

But it works, thank you very much

Was this reply helpful? Yes No