Combining Array to a Text

[Keith_Cheung]

I have an array of query and with iterator, each of the term under and array is passed to search for results from Google sheet. And each search term will return a list of results which I’m using text aggregator to put into a format I wanted.

I would like to combine the text aggregated in different bundles into a single text output and use webhook response. I can’t seem to get it combine with array aggregator / text aggreagator.

any advice please. Thank you very much

blueprint.json (33.9 KB)

module 12 output

module 14 output (one of the bundle)

module 6

[samliew]

Looks like one aggregator’s “Source module” should be set to the Iterator, and the other aggregator should be set to the “Search” module.

If you need further assistance,

1. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

^{(Note: Exporting your scenario will not include private information or keys to your connections)}

Uploading it here will look like this:

blueprint.json (12.3 KB)

2. And most importantly, Output bundles

Please provide the output bundles of the modules [12] and [14] by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

• Either add three backticks ``` before and after the code, like this:

  ```
  <sup>input/output bundle content goes here</sup>
  ```

• Or use the format code button in the editor:
  

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

[Keith_Cheung]

Many thanks! details are uploaded.

[samliew]

Try something like this:

[Keith_Cheung]

Great thanks!! my next challenge is how do I only append a maximum of 9 bundles and drop anything beyond that? I only need the first 9 (or no less than 1) and aggregate to a single text

[samliew]

No problem, glad I could help!

You can try using a built-in function slice https://www.make.com/en/help/functions/array-functions#slice--array--start---end--

But you’ll have to Parse JSON first, since it’s already aggregated to text.

In future, please create a new thread for each question. This makes it easier for others with the same problem to search for the answer. Thank you for your cooperation!

The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

• others can save time when catching up with the latest activity here, and
• allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question: