Getting a nested map within json data

Question

I have JSON data such as this:

var data = '{"credit":{"@code":"NT2C8FFC","card":"NT2C8FFC","credit":"149.96","amount":"149.96","disabled":"0","expired":"2011-02-15 10:21:18","user":"xxxx","issued":"2010-02-15 10:21:18","orderid":[],"fromorder":[],"email":"xxxx","phone":[],"state":[],"address":[],"city":[],"zip":[],"country":[],"customerid":"xxx","order":"xxx","order_date":"2010-01-23 00:00:00","reason":"Product Not Working as Expected","source":"xxx","first":[],"last":[],"notes":[]}}'

It is actually being returned to me as JSON. I am just displaying it here like this for example sake. I can use data["credit"] to get the element called credit but that only gets me :

{"@code":"NT2C8FFC","card":"NT2C8FFC","credit":"149.96","amount":"149.96","disabled":"0","expired":"2011-02-15 10:21:18","user":"xxxx","issued":"2010-02-15 10:21:18","orderid":[],"fromorder":[],"email":"xxxx","phone":[],"state":[],"address":[],"city":[],"zip":[],"country":[],"customerid":"xxx","order":"xxx","order_date":"2010-01-23 00:00:00","reason":"Product Not Working as Expected","source":"xxx","first":[],"last":[],"notes":[]}

How can I drill down to one shot? data["credit"]["credit"] is not proper syntax. It results in undefined. I know I'm close but can't remember the rest. The goal is to get 149.96 from the JSON data.

@ExplosionPills, your Fiddle does not include the quotes around the data which is why it works — ͢bts
– ͢bts, Commented Apr 10, 2013 at 7:15
possible duplicate of I have a nested data structure / JSON, how can I access a specific value? — Felix Kling
– Felix Kling, Commented Apr 10, 2013 at 15:51
Could it be that you somehow double encoded your data and data.credit is a actually a string containing JSON? If so, fix your data! — Felix Kling
– Felix Kling, Commented Apr 10, 2013 at 15:54

A J · Accepted Answer · 2013-04-10 07:31:51Z

1

For now you can use alert(data.credit.credit).

        var data = '{"credit":{"@code":"NT2C8FFC","card":"NT2C8FFC","credit":"149.96","amount":"149.96","disabled":"0","expired":"2011-02-15 10:21:18","user":"xxxx","issued":"2010-02-15 10:21:18","orderid":[],"fromorder":[],"email":"xxxx","phone":[],"state":[],"address":[],"city":[],"zip":[],"country":[],"customerid":"xxx","order":"xxx","order_date":"2010-01-23 00:00:00","reason":"Product Not Working as Expected","source":"xxx","first":[],"last":[],"notes":[]}}';
        eval("data=" + data);
        alert(data.credit.credit);

You can also use data = JSON.parse(data); to convert the string into Json but this has browser compatibility issues.

These are the browsers that supports

Firefox (Mozilla) 3.5
Internet Explorer 8
Chrome
Opera 10
List item
Safari 4

Older versions dont support.

edited Apr 10, 2013 at 7:31

answered Apr 10, 2013 at 7:18

A J

2,14015 silver badges24 bronze badges

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

7 Comments

͢bts Over a year ago

. or [] syntax will both work correctly for an object. Using [] syntax allows a variable to be used between the brackets, i.e. var c='credit';console.log(data[c]);

jQuery Junkie Over a year ago

The example of "data" in the context is data being returned as a JSON object. That was why I used data["credit"]. I just can't get the inner credit.

jQuery Junkie Over a year ago

"data" is a JSON object. My bad for putting quotes around it. data.credit.credit returns undefined.

Felix Kling Over a year ago

"You can also use data = JSON.parse(data); to convert the string into Json": No no no! You use JSON.parse to convert JSON into a native object / array. If you wanted to create JSON, you would take an existing object/array and pass it to JSON.stringify. There is no such thing as a JSON object.

A J Over a year ago

@FelixKling: And what about the browser compatibility issues? Say I want this on IE7..will JSON.parse work?

|

bipen · Accepted Answer · 2013-04-10 06:46:23Z

0

use . operator to get the object's object

alert(data.credit.credit) //gives 149.96
 alert(data.credit.amount) //gives 149.96
alert(data.credit.card) //gives NT2C8FFC

answered Apr 10, 2013 at 6:46

bipen

36.6k9 gold badges51 silver badges62 bronze badges

Comments

͢bts · Accepted Answer · 2013-04-10 07:32:07Z

You are making data a string not an object. Change

var data = '{"credit":{"@code":"NT2C8FFC","card":"NT2C8FFC","credit":"149.96","amount":"149.96","disabled":"0","expired":"2011-02-15 10:21:18","user":"xxxx","issued":"2010-02-15 10:21:18","orderid":[],"fromorder":[],"email":"xxxx","phone":[],"state":[],"address":[],"city":[],"zip":[],"country":[],"customerid":"xxx","order":"xxx","order_date":"2010-01-23 00:00:00","reason":"Product Not Working as Expected","source":"xxx","first":[],"last":[],"notes":[]}}'

to

var data = {"credit":{"@code":"NT2C8FFC","card":"NT2C8FFC","credit":"149.96","amount":"149.96","disabled":"0","expired":"2011-02-15 10:21:18","user":"xxxx","issued":"2010-02-15 10:21:18","orderid":[],"fromorder":[],"email":"xxxx","phone":[],"state":[],"address":[],"city":[],"zip":[],"country":[],"customerid":"xxx","order":"xxx","order_date":"2010-01-23 00:00:00","reason":"Product Not Working as Expected","source":"xxx","first":[],"last":[],"notes":[]}}

If you can't change the original data you will need to parse it by doing

data = JSON.parse(data);

(which will work in most browsers) or use a method from a library such as JQuery's:

data = jQuery.parseJSON(data);

Collectives™ on Stack Overflow

Getting a nested map within json data

3 Answers 3

7 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

Comments

Related