Iterate and search a JSON array for the element in the array

Question

I have a JSON array that looks like this:

response = {
    "items"=>[
        {
            "tags"=>[
                "random"
            ],
            "timestamp"=>12345,
            "storage"=>{
                "url"=>"https://example.com/example",
                "key"=>"mykeys"
            },
            "envelope"=>{

            },
            "log-level"=>"info",
            "id"=>"random_id_test_1",
            "campaigns"=>[

            ],
            "user-variables"=>{

            },
            "flags"=>{
                "is-test-mode"=>false
            },
            "message"=>{
                "headers"=>{
                    "to"=>"[email protected]",
                    "message-id"=>"[email protected]",
                    "from"=>"[email protected]",
                    "subject"=>"new subject"
                },
                "attachments"=>[

                ],
                "recipients"=>[
                    "[email protected]"
                ],
                "size"=>4444
            },
            "event"=>"stored"
        },
        {
            "tags"=>[
                "flowerPower"
            ],
            "timestamp"=>567890,
            "storage"=>{
                "url"=>"https://yahoo.com",
                "key"=>"some_really_cool_keys_go_here"
            },
            "envelope"=>{

            },
            "log-level"=>"info",
            "id"=>"some_really_cool_ids_go_here",
            "campaigns"=>[

            ],
            "user-variables"=>{

            },
            "flags"=>{
                "is-test-mode"=>false
            },
            "message"=>{
                "headers"=>{
                    "to"=>"[email protected]",
                    "message-id"=>"[email protected]",
                    "from"=>"[email protected]",
                    "subject"=>"email_looks_good"
                },
                "attachments"=>[

                ],
                "recipients"=>[
                    "[email protected]"
                ],
                "size"=>2222
            },
            "event"=>"stored"

        }]
}

I am trying to obtain the "storage" "url" based on the "to" email. How do I iterate through this array where x is just the element in the array

response['items'][x]["message"]["headers"]["to"]

Once I find the specific email that I need, it will stop and return the value of x which is the element number. I was going to use that value for x and call response['items'][x]['storage']['url'] which will return the string for the URL.

I thought about doing this but there's gotta be a better way:

x = 0
user_email = [email protected]
while user_email != response['items'][x]["message"]["headers"]["to"] do
  x+=1
  value = x
  puts value
end

Welcome to Stack Overflow. It's important to strip data to the minimum necessary to demonstrate the problem. Anything beyond that only slows our ability to help you. — the Tin Man
– the Tin Man, Commented Aug 27, 2015 at 22:50

alf · Accepted Answer · 2015-08-27 22:37:26Z

2

target = 
  response['items'].detect do |i| 
    i['message']['headers']['to'] == '[email protected]'
  end

then

target['storage']['url']

edited Aug 27, 2015 at 22:37

alf

18.6k10 gold badges64 silver badges93 bronze badges

answered Aug 27, 2015 at 22:33

satoru

33.4k35 gold badges101 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

adbarads Over a year ago

thanks, I was able to verify that in irb. I was ripping my hair out trying everything in irb wasn't working. I learned a new method today. "detect" Thanks so much!

Cary Swoveland Over a year ago

Are you sure the OP didn't want i['message']['headers'].key?('to')? Do we know that target != nil?

satoru Over a year ago

Are you sure that's the same question?

adbarads Over a year ago

@CarySwoveland - yeah, doing that will make the code more robust. Ideally, it should never be nil. But you never know. if it is nil it won't be too catastrophic. Thanks for the comment.

adbarads Over a year ago

@satoru - could i use a regex? (trying to do domain matching: i['message']['headers']['to'] == /example.com/

|

Gagan Gami · Accepted Answer · 2015-08-28 06:43:02Z

1

This is another option by creating Hash with key of to's email. And on basis of it fetch required information like this:

email_hash = Hash.new
response["items"].each do |i|
   email_hash[i["message"]["headers"]["to"]] = i
end

Now if you want to fetch "storage" "url" then simply do:

user_email = "[email protected]"
puts email_hash[user_email]["storage"]["url"] if email_hash[user_email]

#=> "https://yahoo.com"

edited Aug 28, 2015 at 6:43

answered Aug 28, 2015 at 6:11

Gagan Gami

10.3k1 gold badge32 silver badges56 bronze badges

Comments

hspandher · Accepted Answer · 2015-08-28 06:46:28Z

0

You can use it as @Satoru suggested. As a suggestion, if you use case involves complex queries on json data (more complex than this), then you can store your data in mongodb, and can elegantly query anything.

answered Aug 28, 2015 at 6:46

hspandher

16.8k2 gold badges35 silver badges49 bronze badges

Collectives™ on Stack Overflow

Iterate and search a JSON array for the element in the array

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related