Welcome to the Make community!
Using Map + Get / First functions to get a value from an array
You can use the built-in functions map and get to access variables within an array.
To do this, you can use the built-in function map —
map(complex array; key; [key for filtering]; [csv-values for filtering])
and the built-in function get (or first) —
get(object or array; path)
so you get something that looks like these —
{{ get(map(1.array; "value"; "name"; "content-type"); 1) }}
{{ first(map(1.array; "value"; "name"; "content-type")) }}
Map function parameters: Step-by-step
To easily remember what each of the parameters of the map function are for, 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.:
In your case, this is probably what you need to get “ADDRESS 1” from the array item with key “businessaddress”:
{{ first(map(1.custom_fields; "text.value"; "key"; "businessaddress")) }}
Make Input Markup: Copy-paste the above into the field, including start/end curly brackets for it to import as intended
Using Map + Join functions to get all values from an array as a concatenated text string
If there are more than one return value in the array, you can combine map and join functions to join the values into a single text string —
``{{ join(map( … ); delimiter) }}```
For more information, the function’s documentation 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