Issue with Make? "Search Persons" Not Processing Bundles Correctly

How To
1

Hi everyone,

I’m encountering an issue with a scenario in Make, where I’m trying to integrate leads from Workiz into Pipedrive. The steps I have are as follows:

  1. HTTP Request: Pulls lead data from Workiz.
  2. Transform to JSON: Converts the data into JSON format.
  3. Parse JSON: Successfully parses the JSON into 9 separate bundles, one for each lead in my example (this is designed to regularly pull new leads in after a certain date).
  4. Set Variable: Used to confirm the phone number being passed through each bundle (I am not sure this step is needed).
  5. Search Persons in Pipedrive: Uses the phone number from the parsed JSON to check if the person exists in Pipedrive.

Here’s where I’m stuck:

  • Parse JSON correctly outputs 9 bundles, each with valid data, including phone numbers.
  • Set Variable, however, only shows 2 outputs instead of 9. These 2 outputs are for the same lead.
  • Search Persons in Pipedrive same as the Set Variable, it only shows 2 outputs for the same lead.

I’ve confirmed the following:

  • The Set Variable module is connected directly to the parsed JSON, so it should iterate through each bundle.
  • The “Term” field in Search Persons is mapped to the correct phone number from the JSON output (e.g., 20. Phone).
  • Exact Match is enabled in the Search Persons module.

My Question:

What could cause Set Variable and Search Persons to fail at processing all 9 bundles after the JSON is parsed? Is there a specific setting or mapping I need to check to ensure it iterates correctly through all the bundles?

Additional Details:

  • The HTTP request is fetching multiple leads (9) from Workiz via a start date parameter.
  • The data structure seems fine coming out of the Parse JSON step.
  • I’ve reviewed the execution history and can see all 9 bundles after the Parse JSON step, but Set Variable and Search Persons don’t process them properly.

Thank you so much for your help!

2

Hi,
You maybe facing this issue due to not combining the individual bundles created from parsing the JSON.
You would probably need to use an array aggregator module between Parse JSON and Set Variable to merge all 9 bundles into one structure before proceeding further
Cheers,
Harsh

3

Harsh,

Thanks so much for the response here! I tried the Array Aggregator and it outputs the 9 bundles in 1 array. I then have the Set Variable as Phone, which flows into Search Persons (Term is Phone from Set Variable and it is searching Phone in Pipedrive. The Output, however, is still showing 2 bundles for the same contact.

Any idea why this might be happening? I am totally at a loss here.

Thanks so much again for the help!