Manipulate json/xml

LorenzoSbeghen · October 17, 2023, 7:04pm

I’m trying to manipulate this xml so it looks like this

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<XML_SOLID TIPO="SOLID">
	<ENGENHARIA>
		<ITEM CODIGO="TESTE" ITEM_BASE="TESTE" DESCRICAO="DESCRICAO" QUANTIDADE="1" MATERIAL="MATERIAL" QUANTIDADE_MATERIAL="0">
			<ESTRUTURA>
				<ITEM CODIGO="202430" ITEM_BASE="000775" DESCRICAO="BORDA PVC 29 X 2,00 MM WENGE (8329 - P06)" QUANTIDADE="1"/>
			</ESTRUTURA>
		</ITEM>
	</ENGENHARIA>
</XML_SOLID>

How can I put the “ITEM” inside the “ESTRUTURA”

MutedJam · October 18, 2023, 9:12am

Hi @LorenzoSbeghen, can you share the JSON data you currently have as text please? This will allow folks on the forum to copy it in their own workflows and help you with building the data transformation logic you’re looking for.

The screenshot appears to only show partial data (and typing in text from screenshots is a rather frustrating and error-prone task in general).

Thank you!

LorenzoSbeghen · October 18, 2023, 11:01am

Sorry,

MutedJam · October 18, 2023, 12:57pm

Thanks @LorenzoSbeghen! These two items look very different. For your result, do you want to use the first item or the second item? Or do you want to insert the second item under the ENGENHARIA key of your first item or something?

LorenzoSbeghen · October 18, 2023, 2:42pm

I need to insert the ITEM into the ESTRUTURA

MutedJam · October 19, 2023, 7:08am

Thanks for confirming @LorenzoSbeghen. I think a workflow like below should do the job based on your example:

Using your example data, it leaves you with the below XML structure:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<XML_SOLID TIPO="SOLID">
	<ENGENHARIA>
		<ITEM CODIGO="TESTE" ITEM_BASE="TESTE" DESCRICAO="DESCRICAO" QUANTIDADE="1" MATERIAL="MATERIAL" QUANTIDADE_MATERIAL="0">
			<ESTRUTURA>
				<ITEM CODIGO="203791" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 B EPS - 675.0 X 50.0 X 15.0 MM" QUANTIDADE="1"/>
			</ESTRUTURA>
		</ITEM>
	</ENGENHARIA>
</XML_SOLID>

LorenzoSbeghen · October 19, 2023, 10:59am

Just one detail, I did the test with more “ITEM” the idea is to close the “ESTRUTURA” the way it is below.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<XML_SOLID TIPO="SOLID">
	<ENGENHARIA>
		<ITEM CODIGO="TESTE" ITEM_BASE="TESTE" DESCRICAO="DESCRICAO" QUANTIDADE="1" MATERIAL="MATERIAL" QUANTIDADE_MATERIAL="0">
			<ESTRUTURA>
				<ITEM CODIGO="203791" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 A EPS RC 450 X 75 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203792" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 B EPS RC 600 X 40 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203793" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 C EPS RC 200 X 135 X 45 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203794" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 D EPS RC 575 X 450 X 10 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203795" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 E EPS RC 450 X 44 X 20 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203796" ITEM_BASE="203092" DESCRICAO="CALCO 200592.1 A EPS RC 800 X 30 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203797" ITEM_BASE="203092" DESCRICAO="CALCO 200592.1 B EPS RC 715 X 715 X 12 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203798" ITEM_BASE="203092" DESCRICAO="CALCO 200592.1 C EPS RC 105 X 105 X 18 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203799" ITEM_BASE="203092" DESCRICAO="CALCO 200592.1 D EPS RC 565 X 85 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203800" ITEM_BASE="203092" DESCRICAO="CALCO 200524.1 A EPS RC 450 X 120 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203801" ITEM_BASE="203092" DESCRICAO="CALCO 200524.1 B EPS RC 450 X 90 X 20 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203802" ITEM_BASE="203092" DESCRICAO="CALCO 200524.1 C EPS RC 190 X 165 X 15 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203803" ITEM_BASE="203092" DESCRICAO="CALCO 200524.1 D EPS RC 580 X 60 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203804" ITEM_BASE="203092" DESCRICAO="CALCO 200524.1 E EPS RC 580 X 105 X 50 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203805" ITEM_BASE="203092" DESCRICAO="CALCO 200590.1 A EPS RC 450 X 120 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203806" ITEM_BASE="203092" DESCRICAO="CALCO 200590.1 B EPS RC 450 X 90 X 20 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203807" ITEM_BASE="203092" DESCRICAO="CALCO 200590.1 C EPS RC 190 X 165 X 15 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203808" ITEM_BASE="203092" DESCRICAO="CALCO 200590.1 D EPS RC 580 X 60 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203809" ITEM_BASE="203092" DESCRICAO="CALCO 200590.1 E EPS RC 580 X 105 X 50 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203810" ITEM_BASE="203092" DESCRICAO="CALCO 200590.1 F EPS RC 450 X 120 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203811" ITEM_BASE="203092" DESCRICAO="CALCO 200603.1 A EPS RC 400 X 85 X 30 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203812" ITEM_BASE="203092" DESCRICAO="CALCO 200603.1 B EPS RC 400 X 65 X 8 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203813" ITEM_BASE="203092" DESCRICAO="CALCO 200603.1 C EPS RC 670 X 40 X 23 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203814" ITEM_BASE="203092" DESCRICAO="CALCO 200603.1 D EPS RC  205 X 170 X 23 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203815" ITEM_BASE="202218" DESCRICAO="CAIXA 880 X 800 X 30 - ELB0030 - PAP S/PARDO " QUANTIDADE="1"/>
				<ITEM CODIGO="203816" ITEM_BASE="202218" DESCRICAO="CAIXA 660 X 450 X 120 - ELB0027 - PAP S/PARDO " QUANTIDADE="1"/>
				<ITEM CODIGO="203817" ITEM_BASE="202218" DESCRICAO="CAIXA 860 X 400 X 120 - ELB0029 - PAP S/PARDO" QUANTIDADE="1"/>
				<ITEM CODIGO="203818" ITEM_BASE="202218" DESCRICAO="CAIXA 860 X 400 X 85 - ELB0034 - PAP S/PARDO " QUANTIDADE="1"/>
			</ESTRUTURA>
		</ITEM>
	</ENGENHARIA>
</XML_SOLID>

How is it getting.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<XML_SOLID TIPO="SOLID">
  <ENGENHARIA>
    <ITEM CODIGO="TESTE" ITEM_BASE="TESTE" DESCRICAO="DESCRICAO" QUANTIDADE="1" MATERIAL="MATERIAL" QUANTIDADE_MATERIAL="0">
      <ESTRUTURA>
        <ITEM CODIGO="203791" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 B EPS - 675.0 X 50.0 X 15.0 MM" QUANTIDADE="1"/>
      </ESTRUTURA>
      <ESTRUTURA>
        <ITEM CODIGO="203791" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 D EPS - 795.0 X 40.0 X 20.0 MM" QUANTIDADE="1"/>
      </ESTRUTURA>
      <ESTRUTURA>
        <ITEM CODIGO="203791" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 C EPS - 450.0 X 105.0 X 105.0 MM" QUANTIDADE="1"/>
      </ESTRUTURA>
      <ESTRUTURA>
        <ITEM CODIGO="203791" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 A EPS - 450.0 X 170.0 X 30.0 MM" QUANTIDADE="1"/>
      </ESTRUTURA>
    </ITEM>
  </ENGENHARIA>
</XML_SOLID>

LorenzoSbeghen · October 25, 2023, 3:27pm

How can I resolve this?

MutedJam · October 26, 2023, 9:53am

Hi @LorenzoSbeghen, I can’t think of a no-code approach for this. So all I can offer is some unholy custom replace logic like so:

This produces an XML structure like this:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<XML_SOLID TIPO="SOLID">
	<ENGENHARIA>
		<ITEM CODIGO="TESTE" ITEM_BASE="TESTE" DESCRICAO="DESCRICAO" QUANTIDADE="1" MATERIAL="MATERIAL" QUANTIDADE_MATERIAL="0">
			<ESTRUTURA>
				<ITEM CODIGO="203791" ITEM_BASE="203092" DESCRICAO="CALCO 200564.1 B EPS - 675.0 X 50.0 X 15.0 MM" QUANTIDADE="1"/>
				<ITEM CODIGO="203793" ITEM_BASE="203094" DESCRICAO="CALCO 200564.1 B EPS - 675.0 X 50.0 X 15.0 MM" QUANTIDADE="1"/>
			</ESTRUTURA>
		</ITEM>
	</ENGENHARIA>
</XML_SOLID>

system · November 2, 2023, 9:53am

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.