appstore_connect_new_api.rb

require 'pry-byebug'
require 'app_store_connect'

private_key_str = ENV['PRIVATE_KEY']
private_key = private_key_str.gsub('\n', "\n")

AppStoreConnect.config = {
  issuer_id: ENV['ISSUER_ID'],
  key_id: ENV['KEY_ID'],
  private_key: private_key
}


require 'csv'
client = AppStoreConnect::Client.new
IDENTIFIER = ENV["IDENTIFIER"]
EXEC_DATE = ENV["EXEC_DATE"] || "2021-03-21"

filter = {
    report_type: 'SALES',
    report_sub_type: 'SUMMARY',
    frequency: 'DAILY',
    vendor_number: ENV['VENDOR_NUMBER'],
    report_date: EXEC_DATE
  }

sales_reports = client.sales_reports(filter: filter)

rows = CSV.parse(sales_reports, col_sep: "\t", headers: true)
# Product Type Identifier: see https://developer.apple.com/forums/thread/24203
data = rows.map{|r| JSON.parse(r.to_hash.to_json)}.
        filter{|r| r['Apple Identifier'] == IDENTIFIER }.
        filter{|d| d["Product Type Identifier"].include?("1") || d["Product Type Identifier"].include?("3")}
puts data