How to extract data from JSON in Ruby on Rails

Question

I have this JSON response from httparty:

{
    "banks": [{
        "sync_frequency": null,
        "code": null,
        "uuid": "2ac14818-59fb-50cf-b3e4-3bddcdfefcae",
        "documents_type": [],
        "color": "003d8f",
        "id": 479,
        "available_transfer_mechanisms": [],
        "auth_mechanism": "credentials",
        "capabilities": ["document"],
        "transfer_beneficiary_types": [],
        "available_auth_mechanisms": ["credentials"],
        "beta": true,
        "months_to_fetch": null,
        "urls": ["https://login.ionos.fr", "https://my.ionos.fr"],
        "siret": null,
        "hidden": false,
        "charged": true,
        "slug": "1&1",
        "categories": [],
        "name": "1&1"
    }, {
        "sync_frequency": null,
        "code": null,
        "uuid": "fabe9547-ba74-5f8c-a790-f5ecc7c4626b",
        "documents_type": [],
        "color": "ffa500",
        "id": 492,
        "available_transfer_mechanisms": [],
        "auth_mechanism": "credentials",
        "capabilities": ["document"],
        "transfer_beneficiary_types": [],
        "available_auth_mechanisms": ["credentials"],
        "beta": true,
        "months_to_fetch": null,
        "urls": ["http://www.avantages-entreprises.com"],
        "siret": null,
        "hidden": false,
        "charged": true,
        "slug": "ACE",
        "categories": [],
        "name": "aceos"
    }, {
        "sync_frequency": null,
        "code": null,
        "uuid": "5f778b18-d10e-5ffd-98a9-ed61d1d39f9b",
        "account_types": ["perp", "madelin", "lifeinsurance"],
        "documents_type": [],
        "color": "005090",
        "id": 406,
        "available_transfer_mechanisms": [],
        "auth_mechanism": "credentials",
        "capabilities": ["bankwealth", "document", "bank"],
        "transfer_beneficiary_types": [],
        "available_auth_mechanisms": ["credentials"],
        "beta": false,
        "months_to_fetch": null,
        "urls": ["https://identification.adis-assurances.com", "https://www.agipi.com", "https://connexion.adis-assurances.com"],
        "siret": null,
        "hidden": false,
        "charged": true,
        "slug": "AGI",
        "categories": [],
        "name": "Agipi"
    }]
}

And i try to get all the "name" values like "1&1", "aceos", "Agipi", etc...

Any idea how to get them ? Thanks

What you have posted is an invalid ruby.

Aleksei Matiushkin
– Aleksei Matiushkin

2019-11-21 10:32:02 +00:00
Commented Nov 21, 2019 at 10:32 — Aleksei Matiushkin
– Aleksei Matiushkin, Commented Nov 21, 2019 at 10:32

Sebastián Palma · Accepted Answer · 2019-11-21 10:29:01Z

2

That looks like an uncomplete JSON response.

Try with JSON.parse, [] and map:

require 'json'

JSON.parse(foo)['banks'].map { |e| e['name'] } # ["1&1", "aceos", "Agipi"]

answered Nov 21, 2019 at 10:29

Sebastián Palma

33.6k6 gold badges45 silver badges65 bronze badges

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

2 Comments

Damien Compère Over a year ago

yes JSON response from httparty sorry for my mistake. When i put the code in my controller I have the error "no implicit conversion of HTTParty::Response into String". Got it, I added .to_s in my request.

Sebastián Palma Over a year ago

It seems you have to use parsed_response. Try with data.parsed_response['banks'] ....

Collectives™ on Stack Overflow

How to extract data from JSON in Ruby on Rails

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related