How can I combine all items returned into one array object?

I used the MySQL node to select some records in my DB. 9 items are returned. I want to send the results all at once to a channel using HTTP Post, however, the HTTP node runs 9 times. How to combine all 9 items returned into one and run the HTTP node only once?

Welcome to the community @Jiu_Kam

The are multiple ways of doing so. You can use the Item List node and aggregate all items into a single thing. That way, the HTTP request only executes once. Or you can use a function node and group them into a single item. Using the Item List node it’s much more straightforward. Check the example below:

Thank you Richard. I’ve used the function node with ‘items’ and it does exactly what I want.

Great that it worked. Have fun.