Search a JSON Response using Ruby

Question

I'm using a Ruby script to interface with an application API and the results being returned are in a JSON format. For example:

{
  "incidents": [
    {
      "number": 1,
      "status": "open",
      "key": "abc123"
    }
    {
      "number": 2,
      "status": "open",
      "key": "xyz098"
    }
    {
      "number": 3,
      "status": "closed",
      "key": "lmn456"
    }
  ]
}

I'm looking to search each block for a particular "key" value (yzx098 in this example) and return the associated "number" value.

Now, I'm very new to Ruby and I'm not sure if there's already a function to help accomplish this. However, a couple days of scouring the Googles and Ruby resource books hasn't yielded anything that works.

Any suggestions?

Answer 1

First of all, the JSON should be as below: (note the commas)

 {
  "incidents": [
    {
      "number": 1,
      "status": "open",
      "key": "abc123"
    },
    {
      "number": 2,
      "status": "open",
      "key": "xyz098"
    },
    {
      "number": 3,
      "status": "closed",
      "key": "lmn456"
    }
  ]
}

Strore the above json in a variable

s =  '{"incidents": [{"number": 1,"status": "open","key": "abc123"},{"number": 2,"status": "open","key": "xyz098"},{"number": 3,"status": "closed","key": "lmn456"}]}'

Parse the JSON

h = JSON.parse(s)

Find the required number using map

h["incidents"].map {|h1| h1['number'] if h1['key']=='xyz098'}.compact.first

Or you could also use find as below

 h["incidents"].find {|h1| h1['key']=='xyz098'}['number']

Or you could also use select as below

h["incidents"].select {|h1| h1['key']=='xyz098'}.first['number']