stats.py

from urllib.request import Request, urlopen
from urllib.parse import quote_plus
import json
import csv

query = "communities:lory"
filename = "output.csv"

query = quote_plus(query)
link = f'https://zenodo.org/api/records?all_versions=true&size=200&q={query}'

def request(link, writer):
    with urlopen(Request(link)) as r:
        data = json.loads(r.read())
        next_link = data['links'].get('next', None)

        for h in data['hits']['hits']:
            self_link = h['links']['self']
            doi = h['metadata']['doi']
            title = h['metadata']['title']
            date = h['metadata']['publication_date']
            views = h['stats']['views']
            downloads = h['stats']['downloads']
            writer.writerow([self_link, doi, title, date, views, downloads])

    return next_link

with open(filename, mode='w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(["URL","DOI","Title","PublicationDate","Views","Downloads"])

    print(f"Requesting {link}")
    link = request(link, writer)
    while link:
        print(f"Requesting {link}")
        link = request(link, writer)