Trouble iterating through multiple records/bundles

I have a scenario that receives input from Salesforce (via Make webhook). Based on the ID received in the webhook, our intent is to query Salesforce, and based on the records returned, iterate on each to send an email.

In my example, I have 2 records returned in the query. I have created the array after the Salesforce search, and added the Iterator and Repeater modules to try and create 2 separate emails.

I can see all of the data I need in one of the arrays, but can’t seem to figure out how to iterate on each record, and create an email using variables from each (independently).

Guidance appreciated!

Added blueprint export here.
blueprint (1).json (223.8 KB)

I also need data from the parent object of the records I"m getting back, so added another Salesforce search step.

My error seems to be happening in the email component, where I"m choosing a mix of array and direct SF search result values.

To summarize:

We start with an APPLICATION. That APPLICATION record has 2 related contact records (each contact record has a lookup field to APPLICATION). I want to use those 2 related contact records, as well as some of the data from the APPLICATION record to populate the email to be sent.

Welcome to the Make community!

I think you’ll need to remove the repeater, otherwise it will send more than one email per iterator.

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. And most importantly, Output bundles

Please provide the output bundles of the modules [18] [27] [28] by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.
Screenshot_2023-10-06_141025

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

2 Likes

Thanks for the feedback! Attached are the output json’s per your suggestion.
[18]Iterator.json (4.6 KB)
[27]Get.json (10.5 KB)
[28]Get.json (10.5 KB)

I rebuilt some of my webhooks and simplified some queries and got it working!

3 Likes

Hi @Brian-HFLA :wave:

I just want to say awesome work getting this up and running :clap:

Thanks a lot for stepping back in here and sharing your progress with the community. We 100% appreciate it :pray:

1 Like