Returns all approved orders from a Google DFP account via their API using their Ruby gem 'google-dfp-api'.

google_dfp_order_service.rb

require 'dfp_api'
dfp = DfpApi::Api.new

order_service = dfp.service(:OrderService, :v201211)
order_results = order_service.get_orders_by_statement({
    :query => 'WHERE status = :order_status LIMIT 500',
    :values => [
        {:key => 'order_status', 
          :value => {:value => 'APPROVED', :xsi_type => 'TextValue'}}
    ]
})

puts order_results