How to generate a complete XML script in a single variable from an Array in Make?

How To
1

Hello everyone,

I have an Array Aggregator output that looks like this (simplified):

json

[
  { "ID PRESTA (J)": "370" },
  { "ID PRESTA (J)": "371" }
]

The number of “ID PRESTA (J)” is variable in my array.

My goal is to dynamically build the following XML script:

<cart_row>
  <id_product>370</id_product>
</cart_row>

<cart_row>
  <id_product>371</id_product>
</cart_row>

:blue_circle: Important:

  • I want the entire XML script inside a single variable (one big block of text).
  • I need it to be done in one operation only.

I tried using a map() and join() inside a Set Variable module but it didn’t work…
it either returns an empty result or an error, depending on my attempts.

:blue_circle: How should I correctly build the map() and join() expression to generate the full XML script in just one variable?

Thank you very much for your help!

Davy

2

Hi @Lash_MASTER
You can iterate the JSON and aggregate the results using the Text Aggregator.

image
image782×563 42.8 KB

image
image1035×701 76.3 KB

image
image467×512 20.1 KB

3

Hi!

Thanks for your help!

In fact I have a deep structure of data and following your advice I iterated 3 times in order to extract the data I need, and then i simply used the text agregator and it works!

In source of the text agregator I used Iterator 58 and in the text field I used the clean data from iterator 59

I guess there are other more optimized solutions, I can t imagine it s so hard to manipulate

Capture d'écran 2025-04-29 130727
Capture d'écran 2025-04-29 1307271303×796 83.5 KB

2 data from a vector. I can t wait to learn more, but for now as a beginner it’s ok for me.

Thanks again!

1 Like
4

@Lash_MASTER, can you share the full JSON? I’ll check if it’s possible to optimize the workflow using array functions.

1 Like