Ruby on rails parse JSON file with rake task

Question

I have an url for JSON object which look like thaht :

{
 "sitesSessions" : {
   "910360_2" : {
    "name": "name",
    "adresse": "adresse"
   },
   "76590_1" : {
    "name": "name",
    "adresse": "adresse"
   }
 }
}

(this is just an example, the real JSON object is very long) and I want to access to "name" and "adresse" in this object.

I need to create a rake task that parse all the document and take name and adresse and insert these in an excel file.

But I don't know how to access to "name" and "adresse" because I have this "910360_2" or "76590_1" that are different for each object in the json ...

Does someone could help me ?

Roman Kiselenko · Accepted Answer · 2017-03-20 07:33:38Z

2

It's very easy, I suggest you read Ruby Hashes.

{
 "sitesSessions" : {
   "910360_2" : {
    "name": "name",
    "adresse": "adresse"
   },
   "76590_1" : {
    "name": "name",
    "adresse": "adresse"
   }
 }
}
>> require 'json'
=> true
>> JSON.parse(f)
=> {"sitesSessions"=>{"910360_2"=>{"name"=>"name", "adresse"=>"adresse"}, "76590_1"=>{"name"=>"name", "adresse"=>"adresse"}}}
>> JSON.parse(f)["sitesSessions"].values
=> [{"name"=>"name", "adresse"=>"adresse"}, {"name"=>"name", "adresse"=>"adresse"}]
>> JSON.parse(f)["sitesSessions"].values.map do |x|
>>   [x['name'], x['adresse']]
>> end
=> [["name", "adresse"], ["name", "adresse"]]

answered Mar 20, 2017 at 7:33

Roman Kiselenko

44.5k9 gold badges100 silver badges111 bronze badges

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

Comments

spickermann · Accepted Answer · 2017-03-20 07:35:45Z

1

It looks like you could just iterate return all values in the hash:

hash = JSON.parse(json)
hash['sitesSessions'].values
#=> [
#     {
#       "name": "name",
#       "adresse": "adresse"
#     },
#     {
#       "name": "name",
#       "adresse": "adresse"
#     }
#   ]

answered Mar 20, 2017 at 7:35

spickermann

108k9 gold badges115 silver badges147 bronze badges

Collectives™ on Stack Overflow

Ruby on rails parse JSON file with rake task

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related