Retrieve Sparkpost Bounces as CSV

sparkpost_bounces_csv.rb

require 'net/http'
require 'json'
require 'csv'

uri = URI('https://api.sparkpost.com/api/v1/message-events?events=bounce,out_of_band')
req = Net::HTTP::Get.new(uri)
req['Content-Type'] = 'application/json'
req['Authorization'] = ENV['API_KEY'] || raise('please provide API_KEY env variable')

res = Net::HTTP.start(uri.host, uri.port, use_ssl: true) do |https|
  https.request(req)
end

bounces = JSON.parse(res.body)['results']
puts "#{bounces.count} bounces found"

CSV.open("bounces.csv", "wb") do |csv|
  csv << %w(Timestamp Recipient Reason)
  bounces.each do |bounce|
    csv << [bounce['timestamp'], bounce['rcpt_to'], bounce['reason']]
  end
end