XML Output Stage - Repetative groups
Posted: Tue Oct 30, 2007 12:22 am
Hi,
I Have a requitement to create a XML with Multiple repitatve goups. How should I give my Input and XML Output stage parameters? What would be appopriate key to set? Do I Need to restucture my Input?
I have used Single repetitative group in XML before, I have also read the XML design document and tried different permutations of xpath as keys and nothing seems to be working.
Thank you,
Joffi.
example of my expected O/P XML will be as follows:
As you see, A. OrderLines B. HeaderCharges C. References are my repetative groups.
My Input: is a denormaized structure as
Order Header | Line Attributes | HeaderCharges attributes| Reference attributes
Expected Output:
<?xml version='1.0' ?>
<Order CustomerPONo="new order 3" OrderNo="1-33775161" EnterpriseCode="ENT-689950" >
<OrderLines>
<OrderLine PrimeLineNo="1" >
<Item ItemDesc="NABI ASSEMBLY" ItemID=" 515-1503-013" UnitOfMeasure="PC" ManufacturerName="687563" ManufacturerItem=""/>
<LinePriceInfo UnitPrice="33"/>
<LineTaxes>
<LineTax Tax="" TaxName="TAX"/>
</LineTaxes>
<OrderDates>
<OrderDate DateTypeId="PROMISE" RequestedDate="2007-10-25T00:00:00-00:00"/>
</OrderDates>
<References>
<Reference Name="SiebelLineID" Value="1-K4CY6"/>
</References>
</OrderLine>
<OrderLine PrimeLineNo="2" >
<Item ItemDesc="LAMB ASSEMBLY" ItemID=" 515-1503-018" UnitOfMeasure="PC" ManufacturerName="687563" ManufacturerItem=""/>
<LinePriceInfo UnitPrice="33"/>
<LineTaxes>
<LineTax Tax="" TaxName="TAX"/>
</LineTaxes>
<OrderDates>
<OrderDate DateTypeId="PROMISE" RequestedDate="2007-10-25T00:00:00-00:00"/>
</OrderDates>
<References>
<Reference Name="SiebelLineID" Value="1-K4CY6"/>
</References>
</OrderLine>
</OrderLines>
<PersonInfoShipTo AddressLine1="2802 Stoney Wood Dr" AddressLine2="Blk 3" AddressLine3="8" />
<PersonInfoBillTo AddressLine1="7777 Windwater Parkway S" AddressLine2="Blk 10" AddressLine3="3"/>
<PriceInfo Currency="USD"/>
<HeaderCharges>
<HeaderCharge ChargeAmount="1" ChargeCategory="Discount" Reference=""/>
<HeaderCharge ChargeAmount="2" ChargeCategory="Shipping"/>
<HeaderCharge ChargeAmount="" ChargeCategory="Tariff"/>
</HeaderCharges>
<HeaderTaxes>
<HeaderTax Tax="" TaxName="TAX"/>
</HeaderTaxes>
<Notes>
<Note NoteText="change order"/>
</Notes>
<References>
<Reference Name="SiebelHeaderId" Value="1-K4CY5"/>
<Reference Name="RevisionNo" Value="3"/>
</References>
</Order>
I Have a requitement to create a XML with Multiple repitatve goups. How should I give my Input and XML Output stage parameters? What would be appopriate key to set? Do I Need to restucture my Input?
I have used Single repetitative group in XML before, I have also read the XML design document and tried different permutations of xpath as keys and nothing seems to be working.
Thank you,
Joffi.
example of my expected O/P XML will be as follows:
As you see, A. OrderLines B. HeaderCharges C. References are my repetative groups.
My Input: is a denormaized structure as
Order Header | Line Attributes | HeaderCharges attributes| Reference attributes
Expected Output:
<?xml version='1.0' ?>
<Order CustomerPONo="new order 3" OrderNo="1-33775161" EnterpriseCode="ENT-689950" >
<OrderLines>
<OrderLine PrimeLineNo="1" >
<Item ItemDesc="NABI ASSEMBLY" ItemID=" 515-1503-013" UnitOfMeasure="PC" ManufacturerName="687563" ManufacturerItem=""/>
<LinePriceInfo UnitPrice="33"/>
<LineTaxes>
<LineTax Tax="" TaxName="TAX"/>
</LineTaxes>
<OrderDates>
<OrderDate DateTypeId="PROMISE" RequestedDate="2007-10-25T00:00:00-00:00"/>
</OrderDates>
<References>
<Reference Name="SiebelLineID" Value="1-K4CY6"/>
</References>
</OrderLine>
<OrderLine PrimeLineNo="2" >
<Item ItemDesc="LAMB ASSEMBLY" ItemID=" 515-1503-018" UnitOfMeasure="PC" ManufacturerName="687563" ManufacturerItem=""/>
<LinePriceInfo UnitPrice="33"/>
<LineTaxes>
<LineTax Tax="" TaxName="TAX"/>
</LineTaxes>
<OrderDates>
<OrderDate DateTypeId="PROMISE" RequestedDate="2007-10-25T00:00:00-00:00"/>
</OrderDates>
<References>
<Reference Name="SiebelLineID" Value="1-K4CY6"/>
</References>
</OrderLine>
</OrderLines>
<PersonInfoShipTo AddressLine1="2802 Stoney Wood Dr" AddressLine2="Blk 3" AddressLine3="8" />
<PersonInfoBillTo AddressLine1="7777 Windwater Parkway S" AddressLine2="Blk 10" AddressLine3="3"/>
<PriceInfo Currency="USD"/>
<HeaderCharges>
<HeaderCharge ChargeAmount="1" ChargeCategory="Discount" Reference=""/>
<HeaderCharge ChargeAmount="2" ChargeCategory="Shipping"/>
<HeaderCharge ChargeAmount="" ChargeCategory="Tariff"/>
</HeaderCharges>
<HeaderTaxes>
<HeaderTax Tax="" TaxName="TAX"/>
</HeaderTaxes>
<Notes>
<Note NoteText="change order"/>
</Notes>
<References>
<Reference Name="SiebelHeaderId" Value="1-K4CY5"/>
<Reference Name="RevisionNo" Value="3"/>
</References>
</Order>