Support

Home Forums Event Espresso Premium EE4 Integration with Zapier

EE4 Integration with Zapier

Posted: August 7, 2018 at 9:03 am


DonBrown

August 7, 2018 at 9:03 am

Hello

I have found that Zapier has a “Trigger App” called MySQL.

Once you connect the MySQL Trigger App to your WordPress MySQL database, you can trigger on an event and ZAP that content to another Zapier App (like Google Contacts, or Google Sheets, or anything else.)

However, to trigger the MySQL App, it asks for several pieces of information which I need help with. They are:

Table/View: (I think I should use: 117_esp_attendee_meta)

Primary Key: ?? what should I use here

Order By: ?? what should I use here

Trigger Column: In my case, I will trigger on ATT_email, because when someone adds a new email to the registration system, I want to Zap their information to my Google Contacts database.

Please help me identify which Database Table Fields I need to use for:

Table/View:
Primary Key:
Order By:

Thanks for your help,
Don


Josh

  • Support Staff

August 7, 2018 at 9:33 am

Hi Don,

I think you’re correct in that you’d use _esp_attendee_meta table. The Primary Key for that table is the ATTM_ID column.

I do not know what you’d put in for the Order by column, because I’m not sure why it needs something for order by. You could probably put ATTM_ID or ATT_ID in for that one.

The support post ‘EE4 Integration with Zapier’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Josh 2 months, 1 week ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!