Export notes from a given DocumentCloud document into a spreadsheet

export_notes.py

import requests
import csv
from documentcloud import DocumentCloud # https://documentcloud.readthedocs.io/en/latest/gettingstarted.html#installation

# Install DocumentCloud Python Wrapper first: https://documentcloud.readthedocs.io/en/latest/index.html

USERNAME = input('Username: ')
PASSWORD = input('Password: ')

client = DocumentCloud(USERNAME, PASSWORD)


documentID = input('Document ID: ')

obj = client.documents.get(documentID)

with open('notes for doc ' + str(documentID) +  '.csv', 'w', newline='') as csvfile:
    fieldnames = ['title', 'note', 'page', 'id']
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    for note in obj.annotations:
        writer.writerow({'title': note.title, 'note': note.content, 'page': note.page, 'id': note.id})