gistfile1.txt

# Fetch a list of siphons for download from AppNexus

extract :DWAPI do
  get 'Siphon'
  limit 2
  
  resolve  do |response|
   rows = []
   response.each do |input|
     name = input[:name]
     hour = input[:hour]
     timestamp = input[:timestamp]
     input['splits'].each do |split|
       rows << { name: name, hour: hour, timestamp: timestamp, split: split['part'] }
     end
   end
   rows
  end

end

load :RDW do
 into :data_siphons
 insert_ignore
end

-------------

etl/apn/data_siphon/fetch.rb:13:in `[]': can't convert String into Integer (TypeError)
        from etl/apn/data_siphon/fetch.rb:13:in `block (3 levels) in initialize'
        from etl/apn/data_siphon/fetch.rb:12:in `each'
        from etl/apn/data_siphon/fetch.rb:12:in `block (2 levels) in initialize'