Join function won't parse array

[Taylor_Vandiver]

Does anyone know why I’m not able to get this array into a string using join()? I have been trying for hours with no results.

I’ve got an iterator/aggregator module combo that is spitting out an array of database ids. then I want to parse that into a comma separated list. Am I doing something wrong here? Or is there another method I should be using?

Thanks for the help.

[samliew]

Welcome to the Make community!

You can use the built-in functions map before you use join to access collection property variables within an array.

e.g.: (paste this in your field)

{{ join(map(54.array; "id"); ",") }}

For more information, see the function documentation in the Help Center, and complete the Make Academy as it is explained in further detail there.

For more information, see Mapping with arrays below:

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

• Help Centre | Tutorials – Make “Manual”
• Make Academy – Basics 101: Learn Make and get certified

Help Centre Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
• How to use Regex in Make - How to use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[Taylor_Vandiver]

Yes!!! That worked! thank you.

[samliew]

No problem, glad I could help!

1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. 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:

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[Taylor_Vandiver]

I’ve had a new problem arise along these same lines. What happens if the array is embedded way down in the bundle like this? I’m trying to get to the “content” within the “Event State” array.

[samliew]

I think you should create a new question with the output bundle.