How to parse the JSON Date format from the below given json data using jquery?

Question

{
"2013\/02\/05":[                        
{"id":"84eb13cfed01764d9c401219faa56d53","colour":"#000000","category":"custom"}
],
}

I have used the jquery code given below.I am trying to access the date '2013/02/05' and the array elements like id ,colour and category of that date.

     $(document).ready(function(){
      var output = $("#changeBtn");
      $("#data").click(function(){
        $.getJSON("json_data.json",function(jd){
               var dates = jd.date;
               alert(dates);
                });
          });

Kevin Bowersox · Accepted Answer · 2013-08-12 23:32:01Z

1

The object returned is an associative array so you can access the property as follows:

$.getJSON("json_data.json",function(jd){
               var dates = jd["2013\/02\/05"][0].colour;
               alert(dates);
 });

JS Fiddle: http://jsfiddle.net/DLKfK/

On a side note, that is a pretty nasty object. I'm not sure why it needs to assign an array to the date property. If you have control over the object I would refactor it. One thing you should definitely refactor is the extra common after the array since this make the JSON invalid.

{
    "2013/02/05": [
        {
            "id": "84eb13cfed01764d9c401219faa56d53",
            "colour": "#000000",
            "category": "custom"
        }
    ], //this comma is invalid
}

edited Aug 12, 2013 at 23:32

answered Aug 12, 2013 at 23:01

Kevin Bowersox

94.6k19 gold badges164 silver badges198 bronze badges

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

8 Comments

balaji Over a year ago

Thanks kevin.I am unable to access the colour object with that date format

balaji Over a year ago

It is an data for an event.On that particular date: the id,colour and category is being displayed in an array

Kevin Bowersox Over a year ago

@balaji Are you sure the object is coming back as you state in your question? I put that into the fiddle and the fiddle works.

Kevin Bowersox Over a year ago

If you log jd to the console does it show the object? Are you testing this in IE? That last comma after the array will break older versions of IE

balaji Over a year ago

/i logged to console.it doesnt retrun any object..I am trying it in the IE 9 version

|

Collectives™ on Stack Overflow

How to parse the JSON Date format from the below given json data using jquery?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related