Support

Home Forums Event Espresso Premium Exporting event data

Exporting event data

Posted: August 5, 2020 at 8:49 am


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

  • Support Staff

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

  • Support Staff

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

You must be logged in to reply to this support post. Sign In or Register for an Account

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: publish

Updated by  Tony 1 month, 3 weeks ago ago

Topic Tags

Tagged: 

Notifications

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