Bulk Load AgileZen Stories

create-stories

require "rest_client"
require "pry"

project_id = "99999"
api_key    = "00000000000000000000000000000000"
url        = ("https://agilezen.com/api/v1/projects/%s/stories" % project_id)

logger = Logger.new($stdout)                                                                                                                                                                                                                                                                                                  

headers = { 
  "X-Zen-ApiKey" => api_key,
  "Accept"       => "text/json"
}

CSV.foreach("stories.csv", headers: :first_row, return_headers: false) do |story|
  payload = { 
    text: story["Story"],
    color: "green",
    size: story["Points"],
    tags: [ "feature" ]
  }.to_json

  begin
    response = RestClient.post(url, payload, headers)
    logger.info "Created: #{story["Story"]}"
  rescue => e
    pry binding
    logger.error "Failed: #{story["Story"]}"
  end 
end

Gemfile

source :rubygems                                                                                                                                                                                                                                                                                                              
                                                                                                                                                              
gem "json_pure"                                                                                                                                               
gem "rest-client"                                                                                                                                             
gem "pry" 

stories.csv