Array into a single text

Hi togehter, i want this array from a json into a single line use in hubspot.

the final result should be:
training_name1#selected_ues1#price_per_ue1;training_name2#selected_ues2#price_per_ue2;training_name3#selected_ues3#price_per_ue3

any ideas how i could manage this?

Hi @Kay_Dollt

Welcome to community.

To aggregate the results of the array (ue_data), please follow these steps:

  1. Use an iterator to sequentially process each element in the array.
  2. Utilize a text aggregator to aggregated text from the array elements.

These steps will ensure the effective aggregation of data from the given array.

Input:
image


Output:

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

3 Likes

I’m curious why you need an iterator? Since the array is already there out of the parse json module why not just use the text aggregator right after parse json.

Using an iterator will generate multiple bundles out of the array and not aggregate all the array data into one text string.

2 Likes

Perfect. Worked for me :heart_hands:

1 Like