Loading Bundle into XML or JSON

How To
1

Hi every one,
I need your help to understand something I’m struggling for hours now :frowning:

Contexte:
I’m loading orders from my Woocommerce eshop on one side, and I need to generate an XML fil to send to my supplier with customer date and product item to deliver.

I’v been able to do the whole process, but I have one point I can’t finlise, which is adding the product items to the XML.

Here is the my scenario

scenario
scenario2168×379 68.2 KB

Here is the agregator configuration;

1.aggregator config
1.aggregator config662×722 47.8 KB

Here is the result of the Aggregator that aggregate all order items:

2.order_items
2.order_items759×729 48.3 KB

we can see that there are 3 items skus and quantity (sorry the XML is in german as required by the supplier)

Now I need to add those items in my final XML so I did a CreateXML node with the following configuration regarding items:

xml output
xml output971×582 41.6 KB

At then end I have only one item in the XML. I can’t manage to have all the 3 items we have in the aggregator output.

Here is the RAW XML output:

raw XML output
raw XML output324×196 2.45 KB

I should have 3 items instead of one like that :

<items>
  <item>
	<shc_nummer>123456</shc_nummer>
	<qty_ordered>2</qty_ordered>
  </item>
  <item>
	<shc_nummer>123456</shc_nummer>
	<qty_ordered>2</qty_ordered>
  </item>
  <item>
	<shc_nummer>123456</shc_nummer>
	<qty_ordered>2</qty_ordered>
  </item>
</items>

So my question is: how should I do to load the Agregator output as a collection in the createXML node ?

Thanks in advance for your help !

2

Hey Gael,

you are only mapping one item in there. Toggle the map button next to the item array variable and it will allow you to map the entire array there, just make sure its following the same structure.

1 Like
3

Oh god ! So easy :slight_smile:
Thanks a lot, you saved me !
I spent so much time to try to find a solution and it was really simple :frowning:

1 Like