Welcome to the Make community!
Did you modify it to your scenario though? Using the map and get/first functions is the correct way to extract values from an array of collections. You cannot copy an answer without knowing how to change it to suit your data.
Combining Map & Get (or First) functions to get Values from Arrays
The built-in functions map, get, first (or `last) allows you to access values within an array containing collections.
First, use the map function on an array, which returns another array of filtered values —
map(array; key; [key for filtering]; [csv-values for filtering])
Then, the built-in function get (or first/last) to get a specific, single item from the resulting array —
get(array; path)
You will get something that looks like these —
{{ get(map(array; "value"; "name"; "content-type"); 1) }}
{{ first(map(array; "value"; "name"; "content-type")) }}
Map Function Parameters: Step-by-Step
To easily remember how to use each of the parameters of the map function, think of it this way:
- From this array (of collections),
- I want to get all the the values for the property/key named _______,
- Where another property/key _______
- has the exact case-sensitive value _______
Example
1. From this array (of collections) user_column_data
2. I want to get all the the values for the property/key named string_value
3. Where another property/key column_id
4. has the exact case-sensitive value EMAIL
5. Output
e.g.:
{{ first(map((1.IMTHEADERS; "value"; "name"; "x-webhook-secret")) }}
Make Input Markup: Copy-paste the above into the field, including start/end curly brackets for it to import as intended
Using Join Function to Transform an Array into a Single Text Variable
You can also combine map with join to join the values into a single text string —
``{{ join(map( … ); delimiter) }}```
e.g.:
{{ join(map(array); ", ") }}
For more information, the documentation for the above functions can be found in the Help Centre and the “Mapping with Arrays” link below. You should also complete the tutorials in the Make Academy, especially Using get() and map() functions.
I’d recommend going through the Make Academy if you haven’t yet!
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 —
Learn Make
- Help Centre | Tutorials – Make’s “manual” - search for help here first
- Make Academy – Basics 101: Learn Make properly to get your money’s worth
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Date Format: tokens for
parseDate| tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
How-Tos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Aggregate an array for mapping complex fields
- Getting started with OpenAI - How to setup and use OpenAI in Make
- Text Parser module - Use pattern matching to extract the text you want
- Webhooks – Make Academy - tutorial on how to use Webhooks
— @samliew