Pick first element from JSON Array with no identifier with jquery

Question

I'm failing to access the number inside the DATA array, which would be the ID mentioned in the COLUMNS.

My JSON is as follows:

{
  "COLUMNS": [
    "ID",
    "DESCRIPTION",
    "DATE"
  ],
  "DATA": [
    [
      53,
      "Try to do something test123",
      "September, 05 2017 00:00:00 +0100"
    ]
  ]
}

My current attempt was this, but with this, I get the whole 3 elements

  var jsonLength= JSON.DATA.length;

  for (dataIndex = 0; dataIndex < jsonLength; dataIndex++) {

      var dataLength= JSON.DATA[dataIndex].length;

      for (noteIndex = 0; noteIndex < dataLength; noteIndex++) {

          alert(JSON.DATA[dataIndex]);

      }
  }

have you tried like thisDATA[0][0]

guradio
– guradio

2017-09-05 08:42:30 +00:00
Commented Sep 5, 2017 at 8:42 — guradio
– guradio, Commented Sep 5, 2017 at 8:42
Now I have thanks to Rory McCrossan's answer.

user4049128
– user4049128

2017-09-05 08:50:30 +00:00
Commented Sep 5, 2017 at 8:50 — user4049128
– user4049128, Commented Sep 5, 2017 at 8:50

Rory McCrossan · Accepted Answer · 2017-09-05 08:42:52Z

3

Your code is almost correct, you're just missing the second index accessor on your 2D DATA array. You can use the noteIndex incrementing variable from your loop:

var JSON = {
  "COLUMNS": [ "ID", "DESCRIPTION", "DATE" ],
  "DATA": [ 
    [ 53, "Try to do something test123", "September, 05 2017 00:00:00 +0100" ] 
  ]
}
var jsonLength = JSON.DATA.length;

for (dataIndex = 0; dataIndex < jsonLength; dataIndex++) {
  var dataLength = JSON.DATA[dataIndex].length;
  for (noteIndex = 0; noteIndex < dataLength; noteIndex++) {
    console.log(JSON.DATA[dataIndex][noteIndex]); // note the additional [] here
  }
}

answered Sep 5, 2017 at 8:42

Rory McCrossan

338k41 gold badges321 silver badges353 bronze badges

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

Comments

Ozgur · Accepted Answer · 2017-09-05 08:45:36Z

1

 var jsonLength= JSON.DATA.length;

  for (var i = 0; i < jsonLength; i++) {

      var note = JSON.DATA[i]
      var id = note[0] // access id value

  }

Also, if you are the owner of server, why not return more suitable and preferred json structure like this? :

[
    {"id": 1, "description": "..."},
    {"id": 1, "description": "..."}
]

answered Sep 5, 2017 at 8:45

Ozgur

3,76620 silver badges35 bronze badges

Collectives™ on Stack Overflow

Pick first element from JSON Array with no identifier with jquery

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