Skip to main content

Hi there I am looking for some help with a zap.

 

In the 3d step of this zap (https://cdn.zappy.app/2fedb5e2925025012e126bfe0939dc26.png) I am getting a list of "companies" with all their associated data via a “get” webhook post.

in the next step (https://cdn.zappy.app/dece74011b9fdad30d1654a3504c2a96.png) I would need to extract from this long list, the "ID" corresponding to the company with the email address sent with my trigger.

You can see this here https://cdn.zappy.app/e84fe0a72d244616a81e1bc01895db04.png

This post has been edited by a moderator to remove sensitive information. Please remember to obfuscate any personally identifiable information prior to posting as this is a public forum. 

So in this example I need to extract the number "29168"

 

Can anyone help me with setting this up ? 

Hey @sweepbright , Do you want to get id of 1st array index OR id’s of all the array index?


hi @jayeshkumarbhatia  

 

thanks for helping out.

 

I need to get the ID of the array which contains the email address sent along in the trigger. 

 

thanks a lot for your help


Hey @sweepbright 

 

 

Hope this solves your problem!


Na that’s a little more complex….lookup table will not work here.  I have multiple arrays coming in from the wbhook which is what you can see in my screenshots


Understood, The alternate solutions i can suggest i s -

  • User Loops by Zapier and than add Filter to match the email
  • The other solution is use Code by Zapier and write custom Javascript/Python code

Below are the help articles

 


ok thanks - so what should that loop do ? 


Hey @sweepbright ,

 

You can add a loop than add a filter to match the email in loop iteration AND from trigger. If filter matches than the Zap will proceed with further actions.