Zube JSON to CSV

zube_to_csv.rb

require 'json'
require 'csv'

data = JSON.parse(File.read("data.json"))

out = CSV.open("data.csv", "wb")

out << ["Number", "State", "Status", "Column", "Epic", "Labels", "Title", "Body"]

row = []
data.each do |record|
  next if record["type"] == "pull_request"
  out << [
    record["number"],
    record["state"],
    record["status"],
    record["category_name"],
    (record["epic"]["title"] rescue ""),
    record["labels"].map { |l| l["name"] }.join(","),
    record["title"],
    record["body"]
  ]
end

out.close