How to get the XML Child and add new row to table

(0) Share

Report

Posted on by bangkalog

I need to split each transaction and insert to table as XML.

Here is the sample XML.

<Universal>
	<Batch>
		<Number>123</Number>
	</Batch
	<TransactionBatch>
		<Trasaction>
			<Id>1</Id>
			<Value>100</Value>
		</Trasaction>
		<Trasaction>
			<Id>2</Id>
			<Value>200</Value>
		</Trasaction>
	</TransactionBatch>
</Universal>

My Current Formula (it has namespace but I did not include in the sample XML)

xpath(xml(outputs('Compose_2')),'string(/*[local-name()="Universal"]/*[local-name()="TransactionBatch"]/*[local-name()="Trasaction"])')

Current Output: 11002200

Expected Output should be:

1st row

<Trasaction><Id>1</Id><Value>100</Value></Trasaction>

2nd row

<Trasaction><Id>2</Id><Value>200</Value></Trasaction>

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @bangkalog ,

you can get an array with the Trasaction using the expression below:

xpath(xml(outputs('Compose')),'//Trasaction') outputs('Compose') is the xml string you shared

If you then loop through that array, each loop will contain one of the Trasaction and you can process it (add as a row).

Was this reply helpful? Yes No