jquery how to get the value of the array of array from json

Question

I have this json

{
  "default": [
    [
      1325876000000,
      0
    ],
    [
      1325876000000,
      0
    ],
    [
      1325876000000,
      0
    ],
    [
      1325876000000,
      0
    ]
  ],
  "direct": [
    [
      1328196800000,
      0
    ],
    [
      1328196800000,
      100
    ],
    [
      1328196800000,
      0
    ],
    [
      1328196800000,
      0
    ]
  ],
  "Sales": [
    [
      1330517600000,
      0
    ],
    [
      1330517600000,
      0
    ],
    [
      1330517600000,
      90
    ],
    [
      1330517600000,
      0
    ]
  ],
  "Support": [
    [
      1332838400000,
      0
    ],
    [
      1332838400000,
      0
    ],
    [
      1332838400000,
      0
    ],
    [
      1332838400000,
      0
    ]
  ]
}

I need to get the value of the of the first array of the last element in that json

in my example I need to get the 1332838400000

I couldn't do that myself. sorry.

`data.Support[0][0]`, Assuming `data` as JSON object. http://jsfiddle.net/sfv4J/ — Satpal, Apr 17 '14 at 13:01
@Satpal Post it as an answer before someone copies you and gets all the glory. — Barmar, Apr 17 '14 at 13:04
@Barmar the content is dynamic. so It is not always `Support` — user2208349, Apr 17 '14 at 13:04
Objects aren't ordered, there's no "last" element of an object. — Barmar, Apr 17 '14 at 13:05
If you don't know the name, and the ordering isn't reliable, which element do you want to select from? — Barmar, Apr 17 '14 at 13:06
@PranaySoni ther is no `support` always. this data is dynamic so sometime we have `support` and another time we have `inbound` and so on — user2208349, Apr 17 '14 at 13:06
use `data[Dynamic][0][0]`,here `Dynamic` a variable which can be `Support` or something else — Satpal, Apr 17 '14 at 13:07
I just told you that objects don't have any order. When you parse the JSON into a Javascript object, there's no way to know which element was originally last. — Barmar, Apr 17 '14 at 13:07
@Barmar my english is bad. maybe i didn't explain good. what I need is always the number in the array that comes with the last element in the json — user2208349, Apr 17 '14 at 13:08
I don't know any way to be clearer, the order isn't preserved when you parse JSON. — Barmar, Apr 17 '14 at 13:09
You need to fix the application so it tells you the property name that was last, then you can use `data[lastProperty][0][0]`. — Barmar, Apr 17 '14 at 13:10
Parse it as a string, get the name of the "last" property and then parse as JSON. You can use the name to get the arrays associated with that property. I don't see why people are getting upset about finding this value when it's in a string - not an object. — Reinstate Monica Cellio, Apr 17 '14 at 13:10
@Barmar i will give you another information. I need always the biggest number in that json. is that work please? — user2208349, Apr 17 '14 at 13:10
@Archer the same one. I need the biggest number. i said that because Baramr told me that it is not possible to answer my qeustion — user2208349, Apr 17 '14 at 13:13
It is possible to answer your question, very easily in fact, but that's even easier. — Reinstate Monica Cellio, Apr 17 '14 at 13:13
Barmar's done what I was just doing - that'll give you the highest value in the data. — Reinstate Monica Cellio, Apr 17 '14 at 13:15

score 1 · Accepted Answer · answered Apr 17 '14 at 13:14

1

To get the highest of the first elements of each of the elements:

var max = -Infinity;
for (var key in json) {
    var arr = json[key];
    if (arr[0][0] > max) {
        max = arr[0][0];
    }
}

answered Apr 17 '14 at 13:14

Barmar

741,623
53
500
612

thanks for answer. but first please check the answer of bukko. is it correct? – user2208349 Apr 17 '14 at 13:14
See the comment I posted on his answer. – Barmar Apr 17 '14 at 13:16
You need to study the difference between arrays and objects in Javascript. – Barmar Apr 17 '14 at 13:16
That will only get the highest value if it's the first value in each array. You need to loop each array as well – Reinstate Monica Cellio Apr 17 '14 at 13:17
but always the array of each item in the json is the same. so i guess this answer is correct for me. i am trying it – user2208349 Apr 17 '14 at 13:20

user3141004 · Answer 2 · 2014-04-17T13:31:32.577

-1

var json = '{"default":[[1325876000000,0],[1325876000000,0],[1325876000000,0],[1325876000000,0]],"direct":[[1328196800000,0],[1328196800000,100],[1328196800000,0],[1328196800000,0]],"Sales":[[1330517600000,0],[1330517600000,0],[1330517600000,90],[1330517600000,0]],"Support":[[1332838400000,0],[1332838400000,0],[1332838400000,0],[1332838400000,0]]}';

var parser = $.parseJSON(json)

var key = keys(parser)
var len = key.length
var last = key[(len-1)]
alert(parser[last][0][0])

edited Apr 17 '14 at 13:31

answered Apr 17 '14 at 13:06

user3141004

115
4

I guess you haven't read the latest comments above, where he says it's not always `Support`. – Barmar Apr 17 '14 at 13:06
it is not always `support` we can't relay on this – user2208349 Apr 17 '14 at 13:09
Sorry, when i wrote this answer there been no comments. Added sample without hardcode. – user3141004 Apr 17 '14 at 13:33

jquery how to get the value of the array of array from json

2 Answers2