Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below XML format from tRestClient and trying to extract Journal, WorkdayID & Combined_Purchase_Orders column. I get all the data for Journal & WorkdayID column but missing only few in
Combined_Purchase_Orders column. Played around loops but nowhere successful with this. I also have few more elements which are at the next node level which are all coming up as empty.
Hi @Poorvi S
Have you tried putting the loop on both Journal, WorkdayID & Combined_Purchase_Orders elements?
hi @Anselmo Peixoto
Tried the above and is just repeating all the values in Combined_Purchase_Orders for each of Journal & WorkdayID and duplicating rows.
Hi @Poorvi S
Could you share a sample of the XML?
<wd:Report_Entry>
<wd:Journal wd:Descriptor="Journal-1">
<wd:ID wd:type="WID">990c0000</wd:ID>
</wd:Journal>
<wd:WorkdayID>99340001</wd:WorkdayID>
<wd:Operational_Transaction wd:Descriptor=" PI-1001746 - XYZ">
<wd:ID wd:type="WID">9904b07082a5901b1ba55ffaf46e0000</wd:ID>
</wd:Operational_Transaction>
<wd:Combined_Purchase_Orders wd:Descriptor="PO-100371">
<wd:ID wd:type="WID">4670000</wd:ID>
<wd:ID wd:type="Document_Number">PO-100371</wd:ID>
<wd:ID wd:type="Purchase_Order_Reference_ID">PURCHASE_ORDER-6</wd:ID>
</wd:Combined_Purchase_Orders>
<wd:Combined_Purchase_Order_Lines wd:Descriptor="PO-100371 - Line 2">
<wd:ID wd:type="WID">764bd0001</wd:ID>
<wd:ID wd:type="Line_Number" wd:parent_type="WID" wd:parent_id="9900000">2</wd:ID>
<wd:ID wd:type="Line_Number" wd:parent_type="Document_Number" wd:parent_id="PO-100371">2</wd:ID>
<wd:ID wd:type="Line_Number" wd:parent_type="Purchase_Order_Reference_ID" wd:parent_id="PURCHASE_ORDER-6">2</wd:ID>
</wd:Combined_Purchase_Order_Lines>
</wd:Report_Entry>
Hi @Poorvi S
From this sample I'm assuming there will be no multiple Journal, WorkdayID or Combined_Purchase_Orders subelements for a single Report_Entry. So I would suggest you put the loop on Report_Entry.
This way the tXMLMap output should look something like this:
Journal-1|99340001|PO-100371
Journal-2|99340002|PO-100372
...