# CrossRef Event Update
### 1. Overview and Context
This procedure updates the Crossref\_Event table in the [SQL Database](https://docs.punctumbooks.com/books/service-component-library/page/sql-database).
### 2. Triggers
The execution of this procedure is usually triggered by
- [Metrics](https://docs.punctumbooks.com/books/service-portfolio-management-spm/page/metrics-process)
### 3. Steps to Be Performed
#### 3.1 Download
CrossRef event data are plucked directly from their [Query API](https://www.eventdata.crossref.org/guide/service/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](https://www.postman.com/web) as a useful API GUI.
#### 3.2 Clean
- You get a JSON file that needs to be [converted](https://www.convertcsv.com/json-to-csv.htm) to CSV.
- Clean up the occurred\_at column by replacing "T" and "Z" with a space, and set data format to timestamp.
- Make sure all columns line up, and all columns have at least one cell filled (even with a dummy)
- Delete header row
#### 3.3 Upload
- Navigate to phpMyAdmin table "Crossref\_Event"
- select Import tab;
- select file
- click "Go."
- archive files under Punctum Admin > Metrics > Crossref Event Data
### 4. Additional Information
### 5. Document Control