EBSCO Ebooks Update

1. Overview and Context

This procedure updates the ~~Crossref_Event~~EBSCO_ebook table in the SQL Database.

2. Triggers

The execution of this procedure is usually triggered by

Metrics

3. Steps to Be Performed

3.1 Download

~~CrossRef event~~The data ~~are plucked directly~~ from ~~their~~ ~~Query API. There~~EBSCO are ~~two~~prepared ~~DOI~~once ~~prefixes~~a ~~punctum~~year ~~uses, so we~~and need ~~records~~to ~~for~~be ~~both.~~requested ~~Just~~by ~~fill~~email. inBe ~~the~~explicit ~~correct~~you ~~start~~want ~~and~~them ~~end~~separated ~~dates:~~

out

https://api.eventdata.crossref.org/v1/events?mailto=vincent@punctumbooks.com&obj-id.prefix=10.53288&from-occurred-date=2023-07-01&until-occurred-date=2023-07-31

per

https://api.eventdata.crossref.org/v1/events?mailto=vincent@punctumbooks.com&obj-id.prefix=10.21983&from-occurred-date=2023-07-01&until-occurred-date=2023-07-31

month.

~~You~~Email ~~can~~Amy ~~use~~Powers: ~~Postman~~apowers@EBSCO.COM ~~as a useful API GUI.~~.

3.2 Clean

~~You~~The ~~get~~data acomes ~~JSON~~in ~~file~~basically ~~that~~useless form and needs to be ~~converted~~fully reformatted in order to ~~CSV.~~

be ~~Clean~~ingested upinto our MySQL database. See the ~~occurred_at~~example ~~column~~from bythe ~~replacing "T" and "Z" with a space, and set~~2023–2024 data ~~format~~in tothe ~~timestamp.~~ ~~Make sure all columns line up, and all columns have at least one cell filled (even with a dummy)~~
~~Delete header row~~folder.

3.3 Upload

Upload into phpMyAdmin table "~~Crossref_Event"~~EBSCO_ebook"

4. Additional Information

5. Document Control

Document ID	PRO-~~045~~046
Document Owner	Vincent
Version	1.0
Last Date of Change	March 26, 2026
Next Review Due Date
Version & Change Tracking