Getting the data from json object in javascript

Question

I have this object from a PHP API:

[Object { span=1,  caption="Particular",  master=true},
Object { span=5,  caption="Loan Class 1"},
Object { span=5,  caption="Loan Class 2"},
Object { span=5,  caption="Loan Class 3"}]

The desired output would be:

## Particular   Loan Class 1    Loan Class 2  Loan Class 3 ##

I tried to do this :

var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;
for (var index in arrData[0]) {
row += index + ',';}
row = row.slice(0, -1);
CSV += row + '\r\n';

What the csv looks like

## span   caption   master ##

Please help how to get the caption value and if there's a script that will output this in excel since there is a need to add some merging of columns.

Show us the JSON, not the print_r output.

T.J. Crowder
– T.J. Crowder

2016-04-07 08:06:39 +00:00
Commented Apr 7, 2016 at 8:06 — T.J. Crowder
– T.J. Crowder, Commented Apr 7, 2016 at 8:06

Barmar · Accepted Answer · 2016-04-07 09:37:06Z

1

You should be iterating over the whole array, not just the object in arrData[0]. And you should not use for (index in object), that just sets index to the keys, not the values. Then to access the captions, you use .caption.

for (var i = 0; i < arrData.length; i++) {
    row += arrData[i].caption + ',';
}

edited Apr 7, 2016 at 9:37

answered Apr 7, 2016 at 8:05

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

1 Comment

bluerain25 Over a year ago

whew its just that i'm quite new to this json and javascript thing. been doing php but with frameworks where there is no need to do front end coding. thank you @barmar just what I needed.

Community · Accepted Answer · 2017-05-23 12:24:11Z

0

For the caption part you could use this:

var row = arrData.map(function(element) {
  return element.caption;
}).join(' ');

.map is used to extract the caption value of all elements in the array. The resulting array values are concatenated with .join. You can specify the separator as a parameter for the .join function.

Writing anything in Excel file format is not trivial. Unless you want the result in CSV format (which your code example implies). For that you might want to take a look at this answer.

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Apr 7, 2016 at 8:52

eschmidt

913 bronze badges

1 Comment

bluerain25 Over a year ago

yes as per discussion with the clients they are fine with csv but if we can do it in excel where we can follow formats from the sample we had much better. as you can see there's that "span" in the object. span is the number of columns for that certain caption

Collectives™ on Stack Overflow

Getting the data from json object in javascript

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related