|
SONIC BLOOM
|
December 23, 2022 at 11:54 am
I have integrated WPForms into Mailchimp, what we are trying to do is track barcode, ticket attendees and names into our zapier. Is there a way to add the barcode into a mailchimp tag, or ideally the Registrations CSV synced into a google sheet would be best.
|
|
Garth
|
December 27, 2022 at 11:21 am
Hi there,
I’m not quite sure I understand what you’re trying to do or what you’re asking.
The barcodes are a representation of the registration code.
If you want to connect Event Espresso to Zapier there is an integration with WP Fusion: https://wpfusion.com/documentation/events/event-espresso/
If you wanted to connect Event Espresso’s data to Google sheets, you’d probably have to use the Event Espresso API and pull the data into Google Sheets (if that’s supported).
Or you can import the Event Espresso data into Sheets manually when you need it.
So, not sure how to answer your question exactly, but there are some options to consider.
|
|
SONIC BLOOM
|
December 29, 2022 at 12:44 pm
I would like to call the api from zapier and export the data to a google sheet (which zapier can do), i would like to get the barcode, attendee id, and first and last name, i have been able to call to the WP-API and made connection, is there a way to get the barcode for tickets that is available in the CSV of registrations page.
|
|
Tony
|
December 29, 2022 at 1:31 pm
The barcode itself? No, its generated on the fly using a JavaScript library.
However, the value used within the barcode is the registration reg_code or reg_url_link, both should work.
I’m a little confused by your question tho, are you asking if you can include the value within the Registration CSV Report generated by Event Espresso or are you wanting to pull the reg_code into Zapier from Event Espresso?
|
|
SONIC BLOOM
|
January 4, 2023 at 1:21 pm
i want to pull the reg_code into zapier from event espresso api
|
|
Tony
|
January 4, 2023 at 2:52 pm
Ok, so what details do you have available to you?
For example, you can get the registrations on and event using:
/wp-json/ee/v4.8.36/events/{event_id}/registrations/
But you’ll have multiple events running at the same time I assume, so what details do you have on your event to send to Event Espresso so you can narrow down the selection?
|
|
SONIC BLOOM
|
January 4, 2023 at 9:37 pm
just one event, ok i am seeing reg code, but now how do i pull their name =includes:name?
|
|
SONIC BLOOM
|
January 4, 2023 at 10:09 pm
i used this to call for the reg code and attendee info…
/wp-json/ee/v4.8.36/events/513/registrations?include=Attendee
but i am not able to get the actual ticket name of what was purchased
|
|
Tony
|
January 5, 2023 at 3:31 am
You can include both the Attendee and Ticket info using:
?include=Attendee,Ticket
|
|
SONIC BLOOM
|
January 5, 2023 at 10:23 am
ok great, i was using includes, instead of include. thank you
|
|
SONIC BLOOM
|
January 5, 2023 at 10:50 am
i am able to populate a google sheet with the data called from the rest api thru zapier, however now when an attendee orders 3 different tickets, it only shows the first ticket in the order, (even though the order contained three tickets) – i will troubleshoot some more but was hoping you had some insight on this
|
|
Tony
|
January 5, 2023 at 3:26 pm
3 tickets for the same event or different events?
|
|
SONIC BLOOM
|
January 5, 2023 at 11:06 pm
same event, one attendee buying 3 tickets.
|
|
Tony
|
January 6, 2023 at 6:55 am
I can’t reproduce this.
If I select 3 of a single ticket type or 3 different ticket types within a event and then register onto those then the:
/wp-json/ee/v4.8.36/events/{event_id}/registrations?include=Attendee
Endpoint shows all 3 of those registrations for both setups.
How are you triggering the call from Zapier?
|
|
SONIC BLOOM
|
January 7, 2023 at 7:41 am
thru webhook, that exact call, but include=Attendee,Ticket
Here are my steps:
Retrieve Webhook by Zapier
Retrieve Poll
Then Create Google Sheet
Create Multiple Spreadsheet Rows
and then populated rows with the data outputs, however it keeps just showing one ticket out of the batch of 3 that a customer would buy.
i.e. General Admission, Glamping, VIP Ticket (if they were buying some for friends too)
Only one of those items would show up , and nothing else would populate on google sheet.
Thru postman i am seeing all the data though.
|
|
Tony
|
January 7, 2023 at 2:15 pm
The fact that your getting all of the data through postman means this is an issue on Zapier with how the rows are being generated.
Its been while since I’ve looked through Zapier now, do you get options on how the rows generate and from what?
|
|
SONIC BLOOM
|
January 8, 2023 at 10:16 am
i get to pick what data goes in each column but not how the rows populate,
|
|
SONIC BLOOM
|
January 10, 2023 at 7:34 am
REG_paid.raw does this column display price with taxes & fees included? if not which value does?
|
