Unlink banners from multiple advertisers in OpenX 2.8

unlink_banners.rb

#!/usr/bin/env ruby
require 'xmlrpc/client'

local = {
  :usr        => "",
  :pwd        => "",
  :host       => "localhost:8888",
  :api_path   => "/openx/www/api/v2/xmlrpc/"
}

prod = {
  :usr        => "",
  :pwd        => "",
  :host       => "",
  :api_path   => "/openx/www/api/v2/xmlrpc/"
}

env = local

advertiser_ids = (1..5)
zone_id = 1

ox = XMLRPC::Client.new2("http://#{env[:host]}#{env[:api_path]}")
session_id = ox.call("ox.logon", env[:usr], env[:pwd])

advertiser_ids.each do |advertiser_id|
  ox.call("ox.getCampaignListByAdvertiserId", session_id, advertiser_id).each do |campaign|
    ox.call("ox.getBannerListByCampaignId", session_id, campaign['campaignId']).each do |banner|
      ox.call("ox.unlinkBanner", session_id, zone_id, banner['bannerId'])
    end
  end
end