|
bhhsflpg
|
August 23, 2022 at 1:35 pm
Hello,
I’ve been trying to use updates to the EE related MySQL tables (New or updated rows) as triggers for various zaps with Zapier. Unfortunately, the related zaps fail more often than they succeed.
To fix this, I’d like to look into the possibility of using webhooks as triggers instead, but have no idea where to start. I’m not a developer, and don’t have one on staff to utilize. Hoping this is something I can DIY?
I need to be able to pull information when the following things occur. If I can
- A new event is added – return event ID
- An existing event is updated – return event ID
- A new registration is received – return registration ID
- A registration is cancelled – return registration ID
- A registrant’s attendance status is changed – return new status and registration ID –
Pretty sure that as long as Zapier has the trigger, and I have an ID number to reference, I can then query the tables for the info I’d need for the rest of the process.
Which Zapier webhook type do I need to use? Retrieve Poll, Catch Raw Hook or Catch Hook? Where would I find the webhook URL that needs to be used, etc?
I feel like these may be stupid questions but don’t know where to begin. Apologize in advance!
Thanks,
Stephanie
|
|
Joao Victor
|
August 24, 2022 at 3:03 pm
Hi there,
I am Joao from the support team!
Event Espresso does not have an official Zapier integration, for this reason, unfortunately, I won’t be very useful regarding your request. In this case, it’s recommended to hire a custom developer if you want to implement this (not sure if it’ll be cheap).
|
|
bhhsflpg
|
August 25, 2022 at 1:02 pm
There’s no documentation anywhere that would give me a clue as to a webhook URL on my installation of the product?
|
|
Tony
|
August 26, 2022 at 8:55 am
Hi Stephanie,
Event Espresso (and WordPress itself for that matter), does not support Webhooks natively. You’ve mentioned you are not a developer so I’ll start giving a quick overview of a webhook.
A webhook is basically a post request sent from your site to a specific URL (or multiple URLs) when {something} is done on the site. That post request can contain data from your site but the important part is that webhooks send the data FROM your site to a specified location, that location ‘listens’ for those requests and processes the request however it has been told to do so.
WordPress itself does not have a webhook feature and we have not built one for Event Espresso, so there are no webhooks within EE at this time. There are actions available throughout both WordPress and Event Espresso which would allow you to crate your functions to hook in and send data to a webhook URL of your own (so in this case send data to Zapier) but we don’t have documentation on doing so as its custom functionality.
Pretty sure that as long as Zapier has the trigger, and I have an ID number to reference, I can then query the tables for the info I’d need for the rest of the process.
So knowing that the webhook sends data to Zapier, how are you going to query the database from Zapier?
Which Zapier webhook type do I need to use? Retrieve Poll, Catch Raw Hook or Catch Hook?
Most likely Catch Hook (catch raw hook is essentially the same but gives you access to the raw body response, the former is parsed).
Retrieve Poll hooks are when you want Zapier to send a request FROM them TO your site, your site parses the request and returns data for Zapier to then parse. As you are wanting the trigger to be from your site, that’s the opposite of what you need.
Where would I find the webhook URL that needs to be used, etc?
This question is why I added the details above, because your asking about a webhook URL which would be generated by Zapier for you to send your post requests mentioned above to.
Zapier will generate a webhook you can use for specific zap, that’s where your code sends its request to and we don’t have documentation on that because it’s not from Event Espresso but Zapier.
I feel like these may be stupid questions but don’t know where to begin. Apologize in advance!
There are no stupid questions! I’ll happily answer any question you have (if I know the answer) but it’s important to note that support from Event Espresso does not cover custom development so eventually my answer may well but something along the lines of ‘this is where you need a developer to help’.
That’s not to avoid helping in the slightest you but there’s only so far we can go with support custom code 🙂
|
