Support

Home Forums Event Espresso Premium Need a JSON export link for events with specific data??

Need a JSON export link for events with specific data??

Posted: December 20, 2019 at 3:42 pm

Viewing 1 reply thread


islandartparty

December 20, 2019 at 3:42 pm

I am not sure how the export link works and how to customize what the data exported is?

I need this data to be in the export and separated:

Event Name
Event Description
Event Price
Featured Image Link
Event Start Date
Event Start Time
Event End Date
Event End Time

Could you show me how to create the JSON link using the REST api (I think that’s what it’s called)

I found another question and answer about this and I found the link I just need it to be customized and I don’t know how to do it.

here’s the one I found but it doesn’t work for me because some info is not there and some is together:
/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

Please help!


Josh

  • Support Staff

December 20, 2019 at 5:43 pm

Hi,

I think this is the other topic you found, https://eventespresso.com/topic/exporting-event-data/#post-264056
and if you follow the step by step instructions there you can get the exported CSV that you can open in a spreadsheet app.

To customize, you remove the entities you don’t want, e.g. remove these:

status,EVT_display_ticket_selector,EVT_default_registration_status,Venue.VNU_name,Datetime.Ticket.TKT_name,

and to add the featured image, you add:

&calculate=image_thumbnail,image_large,image_medium

(If you only need one of the image sizes you can remove two from the above)

Viewing 1 reply thread

The support post ‘Need a JSON export link for events with specific data??’ 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.

Event Espresso