KM People JSON to CSV

km_json_to_csv.rb

require 'csv'

data = {
  # simplifying returned results
  "total" => nil,
  "links" => [],
  "metadata" => {},
  "columns"=> [
    {
      "display_name"=>"KMID",
      "type"=>"internal",
      "return_option"=>"internal",
      "display_return_option"=>"internal"
    },
    {
      "display_name"=>"Person",
      "type"=>"internal",
      "return_option"=>"internal",
      "display_return_option"=>"internal"
    },
    {
      "type"=>"event",
      "display_name"=>"Visited Site",
      "return_option"=>"total_times_ever",
      "display_return_option"=>"Total Times Ever"
    }
  ],
  "rows"=> [
    [12345, "[email protected]", 22]
  ]
}

CSV.generate do |writer|
  writer << data.fetch('columns').map {|column| column.fetch('display_name', '')}
  data.fetch('rows').each do |row|
    writer << row
  end
end