CrossRef Event Update

1. Overview and Context

This procedure updates the Thoth_CDNCrossref_Event 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

TheCrossRef CDNevent operated by Thoth provides access to our PDF files (books.punctumbooks.com). The CDN also generates usage metrics. Theydata are providedplucked ondirectly from their Query API. There are two DOI prefixes punctum uses, so we need records for both. Just fill in the correct start and end dates:

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

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

You can use Postman as a quarterlyuseful basisAPI by Javi from Thoth Open Metadata until an automated system is developed.GUI.

3.2 Clean

• deleteYou get a JSON file that needs to be converted to CSV.

Clean up the occurred_at column event_uriby replacing "T" and "Z" with a space, and set data format to timestamp. inMake work_uri,sure removeall thecolumns DOIline prefixesup, and .1.00all columns have at theleast endone suchcell that only the PBN remainsfilled (makeeven surewith thea format is set to "Text" to preserve the initial zero)dummy)
doubleDelete checkheader that all PBNs are correct (with initial zero) delete the rows with the other publishers
row

3.3 Upload

• Upload to theinto phpMyAdmin table "Thoth_CDN"Crossref_Event"
  

4. Additional Information

5. Document Control

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