Hi @johnanderson ,
Welcome to Make Community!
We have a couple of solutions for you, please check the below images and notes.
We are providing the function below so that you can copy and paste this into your scenario and change the mappings.
{{get(map(1.data; "accountId"; "emailAddress"; "john.smith@test123.com"); 1)}}
Second Method:-
Use an iterator and map the whole array to it as shown below.
After the iterator add a filter for matching the email.
Once the filter is added you can simply map the account id directly.
For a better understanding please watch the loom below.
Loom : https://www.loom.com/share/0dd926370c374c128e37e2a95ca6b9db?sid=c5cff3af-6223-4003-a2d4-b4d494e6301e
Regards,
Msquare Automation - Gold Partner of Make
Explore our YouTube Channel
for valuable insights and updates!