Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I’m trying to create a Mixpanel Trigger in Zapier using Webhooks, and have a question about how the payload is handled. 

Mixpanel says that they’re sending in an array of json blobs for each user as below: 
 

 

When Zapier gets the payload, it is rendered as one giant string (as below): 

 

If I choose to “Pick off a child key” and set the value to ‘users’, then zapier seems to be able to parse the values appropriately. However, I am only seeing one users values as below (when really it should be an array of many) ...

 

I’d think I read somewhere that Zapier does in fact handle arrays appropriately in the backend, but for some reason, the UI and test steps only show one value? Is that accurate in this case? 

Thank you!!

Instead of picking it off, have you tried splitting on $distinct_id

Thanks! that appears to work for getting each user separately into an array, but subsequent steps only seem to be letting me access it as one giant value. 

See the output below, which is great.

But I’d like to be able to parse the json blob for properties for each value in the array. However, when I try to access the output in a subsequent code step, it shows as below

 

and appears to come in as one giant string. 

Is there a way to access it as an array? Zapier’s UI on this is confusing me a bit

Update! (in case anyone else runs into the same problem)

I change the webhook to a Raw request, and am now using the below logic to parse the information: 

 

 

It gives it to me like below: 

 

which is what i’d been looking for! 

 

May be a roundabout way of doing it, but it’s working for me :)

Terms & Conditions