From google sheet to an XML

How To
,
1

I have a Google Excel sheet with several column and lines

Each line should be one item from my xml

I created the scenario bellow:

this is my google sheet:

Capture d’écran (29)
Capture d’écran (29)525×237 6.4 KB

and the scenario is here:
Capture d’écran (23)
Capture d’écran (23)3429×695 149 KB

First I defined My google sheet:
Capture d’écran (24)
Capture d’écran (24)644×1026 51.4 KB

Then I have my Iterator (i tried without, directly with array integrator it didnt work neither):
Capture d’écran (25)
Capture d’écran (25)1016×439 46.6 KB

Then I have my array integrator :
Capture d’écran (26)
Capture d’écran (26)912×1294 98.6 KB

An then My xml generator:
Capture d’écran (30)
Capture d’écran (30)799×1298 80.8 KB

Capture d’écran (27)
Capture d’écran (27)1088×690 54.8 KB

But the issue is my XML generated contain only one element:
Capture d’écran (28)
Capture d’écran (28)764×130 10.3 KB

Instead of each item.
What should i change to get all of them ?

2

Hi @GabGE

Thanks for reaching out to the community. In this case, we advice you to build the XML format using the Text Aggregator module.

The fixed lines can be stored in a Set Variable module connected after Text Aggregator module.

In Text Aggregator module, aggregate the line items with all formatting mentioned in Text field.

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live

Explore our YouTube Channel for valuable insights and updates!