|
Troy
|
August 5, 2020 at 8:49 am
Hello. I had asked this question before. I would like to export event data (preferably into a spreadsheet). A couple years ago you suggested I use https://json-csv.com/ using this format:
http://example.com/wp-json/ee/v4.8.36/events?order_by=EVT_ID&sort=DESC&limit=200&include=Datetime.DTT_EVT_start,Datetime.DTT_EVT_end,EVT_name,EVT_desc,status,EVT_display_ticket_selector,EVT_default_registration_status,Venue.VNU_name,Datetime.Ticket.TKT_name,Datetime.Ticket.TKT_price,Datetime.Ticket.TKT_end_date
and change the site address to our own. It no longer works. Any idea what I need to update to make it function?
Or maybe there is a better way to export?
|
|
Tony
|
August 5, 2020 at 9:33 am
Hi Troy,
When you say it no longer works, may I ask what happens?
I’ve just used the above on the site linked to your license and got a list of events. It takes a little for the site to pull all of the info in but as long as you keep the page open for a little it works for me.
That link is using the REST API to pull the data from Event Espresso, we haven’t changed how that works since 4.8.36.p (which is one of the reasons we use the version number in the URL itself).
|
|
Troy
|
August 5, 2020 at 10:03 am
Tony – That is so weird. I tried it three times with errors and now it works. Is there a way to add in the following:
Event datetimes limit
Event datetimes Sold
Ticket Sale Starts
Ticket Sell Until
Ticket Qty
Event Categories
Questions for Primary Registrant
Questions for Additional Registrants
Lastly, it is showing expired class dates, can those be eliminated?
Since we have so many events, this would be an easy cross check to look for mistakes in how our classes are entered.
|
|
Tony
|
August 7, 2020 at 6:30 am
For some, sure, you just add them to the include:
Event datetimes limit = Datetime.DTT_reg_limit
Event datetimes Sold = Datetime.DTT_sold
Ticket Sale Starts = Datetime.Ticket.TKT_start_date
Ticket Sell Until = Datetime.Ticket.TKT_end_date (this is already included in your request)
Ticket Qty = Datetime.Ticket.TKT_Qty
I don’t think you can include these on the same request but will check with our developers to confirm:
Event Categories,
Questions for Primary Registrant,
Questions for Additional Registrants
|
