Exporting a calendar group's past events

LiveWhale
1

I have a calendar group requesting an export of all past events in the system. Is there a way to do this?

2

Hi Jamie,

Yep! Probably the /live/csv/events API endpoint is the easiest way to do this.

/live/csv/events/group/My Group/ will download a CSV of all upcoming events published from a group

And you can use something like /live/csv/events/group/My Group/start_date/-10 years/end_date/+10 years/ will get you the same thing but with a wider time range

Or, if you want more fine-tuning over the results, you can also create a new Widget to grab the events that you want, and then use the formatting tools to manually make an HTML table (copy/paste from browser into Excel) or a CSV.

3

I’m sorry. I’m not really sure what the first part means. Can you walk me through it?

4

Hi Jamie,

Sure thing – documentation about the API is here, but I can give a few examples. Your calendar is at https://events.berkeley.edu/ right?

Starting from there, you can download a CSV of upcoming events from all groups by clicking this link and saving the contents (most browsers download automatically):
https://events.berkeley.edu/live/csv/events/

Or, if you just wanted events from a single group – say, the Arts Research Center, you can add that as a /group/ filter to the request:
https://events.berkeley.edu/live/csv/events/group/Arts Research Center/

And lastly, you can add start_date and end_date to also capture past events, like this:
https://events.berkeley.edu/live/csv/events/group/Arts Research Center/start_date/-2 years/end_date/+2 years/.