appstore.rb

# encoding: UTF-8

require 'csv'
require 'json'

columns = %w(trackName trackViewUrl artistName version price releaseDate formattedPrice fileSizeBytes description)
exclude = [] # Here you can execlude list of urls you want

data = JSON.load(DATA.read)
puts data.count

CSV.open("export.csv", "w") do |csv|
  csv << data.first.keep_if {|key, value| columns.include?(key) }.keys
  data.each do |hash|
    appurl = hash['trackViewUrl']
    # unless appurl.nil?
    #   appurl = appurl.split('?')[0]
    # end

    if !exclude.include?(appurl)
      csv << hash.keep_if {|key, value| columns.include?(key) }.values
    end
  end
end

__END__