Here’s a quick Python Script that connects to PagerDuty’s API and pulls down the incident ID, description, and notes for all incidents in a given date range. It’s useful for appending to an existing CSV download via VLOOKUP, particularly PagerDuty’s new Advanced CSV Export.

I hope this is useful to you!

# -*- coding: utf-8 -*-

# This script requires pygerduty: https://github.com/dropbox/pygerduty

# Given a start date and end date, this sample will export the description and
# notes from all incidents to a CSV file. The CSV file is formatted for use
# with Excel. This will export to incident_notes_[start date]_-_[end date].csv
# This would be most useful to join with a CSV file as exported from PagerDuty.

# Usage: edit subdomain and specify an API key (must have full access) below.
# (What's the subdomain? Example: http://demo.pagerduty.com --> "demo")
# Then run: python incidents.py [start date: YYYY-MM-DD] [end date: YYYY-MM-DD]
# Example: python incidents.py 2015-01-01 2015-03-31

import pygerduty
pager = pygerduty.PagerDuty("SUBDOMAIN", "APIKEY")

import sys
startdate, enddate = sys.argv[1:]

# This function escapes quotes in notes in a way that's Excel compatible.
# All other characters, including comma and new-line, are handled correctly
# by way of being included within the surrounding quotes.

def escape( escape_me ):
	escape_me = escape_me.replace("\"", "\"\"")
	return escape_me

my_filename = "incident_notes_%s_-_%s.csv" % (startdate, enddate)
with open(my_filename, 'w',1) as the_file:
	the_file.write("Incident ID,Description,Notes\n")
	for incident in pager.incidents.list(since=startdate, until=enddate):
		if hasattr(incident.trigger_summary_data, 'subject'):
			my_description = incident.trigger_summary_data.subject
		elif hasattr(incident.trigger_summary_data, 'description'):
			my_description = incident.trigger_summary_data.description
		my_line = '%s,"%s","' % (incident.incident_number, escape(my_description))
		my_count = 0
		for note in incident.notes.list(incident_id=incident.incident_number):
			my_count += 1
			if my_count > 1:
				my_line += "\n"
			my_line += "%s, %s: %s" % (escape(note.user.name), escape(note.created_at), escape(note.content))
		my_line += "\"\n"
		the_file.write(my_line)