Difficulty sending personalized email with information split in two tables that do not have all common points

@ThinhDinh - I made decent progress with invoking the zap where I send the JSON Payload and the number of JSON Objects in it as 2 values to my Zap.

I wrote a 3 step Zap where I use Code by Zap (using Python) where I put the objects in a dictionary and then invoke Send Outbound email by Zapier.

I’ve a problem sending this JSON Payload to my Zap as when I trigger the action from my Glide app and look at the Zap run, the value corresponding to JSON Payload doesn’t seem to be present. I tried to pass a lookup column, then changed to a Single value column, a text column. No luck!

My Zap definition from Glide:

This is that single value column that I set in my Zap trigger:

image

And when I click on the button that triggers this Glide action in my app, It calls the Zap and fails there with the following:

Though I pass 2 values, in the zap output only Value 2 is passed.

Anything catches anybody’s eye?

Just to test the zap, I tested the entire step by hardcoding the same JSON in my Code By Zap test and it neatly picks up each JSON Object and sends an email as I expect to.

This is my code test in Zap:

This is my Email step in Zap: