Upcoming Events Report: Difference between revisions
Jump to navigation
Jump to search
Peterstevens (talk | contribs) m Fixed confusingly worded sentence about braces. |
Peterstevens (talk | contribs) m Combined similar steps. |
||
| Line 1: | Line 1: | ||
# Navigate to <nowiki>https://ces.fas.harvard.edu/api/events/between/YYYY-MM-DD/YYYY-MM-DD</nowiki> | # Navigate to <nowiki>https://ces.fas.harvard.edu/api/events/between/YYYY-MM-DD/YYYY-MM-DD</nowiki> | ||
# Copy the data | # Copy and paste the data into http://www.jsonquerytool.com/. Make sure query type is JSONPath | ||
# Run this expression: | # Run this expression: | ||
$.items[?(@.calendar=='public')].['title','startDateTime','endDateTime'] | $.items[?(@.calendar=='public')].['title','startDateTime','endDateTime'] | ||
Revision as of 13:30, 14 September 2018
- Navigate to https://ces.fas.harvard.edu/api/events/between/YYYY-MM-DD/YYYY-MM-DD
- Copy and paste the data into http://www.jsonquerytool.com/. Make sure query type is JSONPath
- Run this expression:
$.items[?(@.calendar=='public')].['title','startDateTime','endDateTime']
- Copy output to Sublimetext.
- Run this Regex expression (including space at beginning):
[0-9]{2}-[0-9]{2}-[0-9]{2}
- Edit all lines to match this format: 12:34:56
- Remove commas, quotation marks, tabs, and square brackets from beginnings and ends of lines. Leave a line break at the end.
- Run this regex expression:
(?:[^\n]*\n){3}
- Change every first and second line break into a tab.
- Copy and paste the whole thing into Excel
- Format dates as March 14, 2018, 12:34pm