loop through JSON results with ruby and sinatra

Question

I am making an API call to Plivo. I would like to loop through the results and print them out as HTML.

The following ruby code:

user_key = 'my_key'
 params = { 'account' => user_key }
 response = p.get_cdrs(params)
 obj = response.last

works and, in the firebug console, I get a bunch of data, example of which is:

["objects", [{"bill_duration"=>2, "billed_duration"=>60, "call_direction"=>"outbound", "call_duration"=>2, "call_uuid"=>"7f1db12e-5a7b-11e3-9c03-c7a22946c980", 
              "end_time"=>"2013-12-01 20:27:08+09:00", "from_number"=>"185258081345", "parent_call_uuid"=>"7e6225d0-5a7b-11e3-9bd4-c7a22946c980",
              "resource_uri"=>"/v1/Account/MAMTE4MTHJNJRKODBIMD/Call/7f1db12e-5a7b-11e3-9c03-c7a22946c980/", 
              "to_number"=>"sip:hechan131129083410@phone.plivo.com", "total_amount"=>"0.00300", "total_rate"=>"0.00300"},

Now when I try to loop though the data with

obj.each do |item|
    bill_duration = item["objects"][0]["call_direction"] 
    halt 200, {:bill_duration => bill_duration}.to_json
   end

I get "TypeError - no implicit conversion of String into Integer:" error in heroku logs. I think my approach may be wrong anyway. Basically, if I don't try to loop, I just get one record. I want them all. How can I do it? Thanks.

It is not a `Hash` but an `Array`. So `item["objects"]` fails. — user2422869, Dec 02 '13 at 09:26
Have you posted an incomplete response? I don't see where the array is closed. — Sergio Tulentsev, Dec 02 '13 at 09:26
yes only a partial array. It was too long other wise. The end is: }]] — user1903663, Dec 02 '13 at 09:46
to answer the question above, if I do not use each but just bill_duration = item["objects"][0]["call_direction"] halt 200, {:bill_duration => bill_duration}.to_json, it works but only displays one record. I need to iterate to get al the records — user1903663, Dec 02 '13 at 09:48
Since you posted another question about the same problem (and received an answer), please delete this one. (http://stackoverflow.com/questions/20340554/ruby-loop-through-data-returned-by-api-call) — Felixyz, Dec 03 '13 at 01:49

loop through JSON results with ruby and sinatra

0 Answers0