Load JSON Data Using jQuery AJAX

Question

I need to print this information when clicking a button and sorting if by date, so far i have this: I have json file that looks like this, but I haven't been able to print it on the page and still haven't got to the sorting by date part. I am not sure if the problem is the link to the ajax version i am using or what is the problem, because i saw an example that looks just like this on youtube and it works just fine.

JSON:

  [
{
    "users": [
        {
            "name": "user1",
            "Endorsement": "some comment",
            "date": "8/11/2012"
        },
        {
            "name": "user2",
            "Endorsement": "some comment2",
            "date": "9/27/11"
        },
        {
            "name": "user3",
            "Endorsement": "some comment3"
        },
        {
            "name": "user4",
            "Endorsement": "some comment4",
            "date": "4/2/13"
        },
        {
            "name": "user5",
            "Endorsement": "some comment5"
        },
        {
            "name": "user6",
            "Endorsement": "some comment6",
            "date": "3/17/13"
        },
        {
            "name": "user7",
            "Endorsement": "some comment7",
            "date": "5/22/13"
        },
        {
            "name": "user8",
            "Endorsement": "some comment8",
            "date": "9/27/13"
        }
    ]
}

]

HTML updated:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Contact</title>
    <link rel="shortcut icon" href="stridesFavicon.ico">
    <link rel="stylesheet" href="css/bootstrap.css">
    <link rel="stylesheet" href="css/bootstrap-responsive.css">
    <link rel="shortcut icon" href='http://sites.google.com/site/lowcoupling/favicon_16x16.ico' />

</head>
<body>
    <!--Body content-->

  <div id='Div1'>


    <a href="#" id="clickme">Get JSON Data</a>


    </div>


    <script type="text/javascript"     src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>



    <script type="text/javascript" src="js/bootstrap.js"></script>
    <script src="myscript.js" type="text/javascript" /></script>
    <script type="text/javascript">

        $(document).ready(function () {
            $('.dropdown-toggle').dropdown();
        });  
    </script>
</body>
</html>

JS updated:

$("#clickme").click(function () {

$.getJSON("users.json", function (data) {

    var items = [];
    $.each(data, function (key, dvalue) {


        $.each(dvalue, function (key, value) {
            items.push('<li id="' + key + '">' + value + '</li>');

        });
    });

    $('<ul/>', {
        'class': 'interest-list',
        html: items.join('')

    }).appendTo('body');

});

});

But is not working. meaning is not loading user names; instead it is printing something like this every time i click the link:

•[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]

<script src="myscript.js" type="text/javascript" /> needs a closing tag, script tags can't be self closing. — user400654
– user400654, Commented Oct 1, 2013 at 17:38
Also, there's no ul on your page for the li's to be appended to. — user400654
– user400654, Commented Oct 1, 2013 at 17:39
Also make sure that you put this code inside document.ready event. — The Alpha
– The Alpha, Commented Oct 1, 2013 at 17:53

Labib Ismaiel · Accepted Answer · 2013-10-01 17:59:39Z

the jason is missing some commas, every line inside the json should end with a comma unless it is the last child in the scope, which makes it:

[
    {
        "users": [
            {
                "name": "user1",
                "Endorsement": "some comment",
                "date": "8/11/2012"
            },
            {
                "name": "user2",
                "Endorsement": "some comment2",
                "date": "9/27/11"
            },
            {
                "name": "user3",
                "Endorsement": "some comment3"
            },
            {
                "name": "user4",
                "Endorsement": "some comment4",
                "date": "4/2/13"
            },
            {
                "name": "user5",
                "Endorsement": "some comment5"
            },
            {
                "name": "user6",
                "Endorsement": "some comment6",
                "date": "3/17/13"
            },
            {
                "name": "user7",
                "Endorsement": "some comment7",
                "date": "5/22/13"
            },
            {
                "name": "user8",
                "Endorsement": "some comment8",
                "date": "9/27/3"
            }
        ]
    }
]

developerCK · Accepted Answer · 2013-10-01 17:40:01Z

2

try !

$("button").click(function () {

$.getJSON("users.json", function (obj) {


    $.each(obj.users, function (key, value) {
        $("ul").append("<li>" + value.name + "</li>");

    });

});

});

and if there is error then use debug console in browser. and either make a fiddle or write what is error. and there seems no ul element in your html.

answered Oct 1, 2013 at 17:40

developerCK

4,5263 gold badges19 silver badges35 bronze badges

2 Comments

Mario V Over a year ago

thanks i added the ul tag, but it still not loading anything; it doesnt show any error either.

Mario V Over a year ago

I fixed the jason and when running it again i got this message SCRIPT5007: Unable to get property 'length' of undefined or null reference jquery.min.js, line 4 character 5189

Rajesh · Accepted Answer · 2013-10-01 17:57:28Z

0

The json is not valid. I validated using http://jsonlint.com/ and it says error at line 6. You left a comma in below part:

"Endorsement": "some comment"  
               "date":"8/11/2012"

This is the first endorsement-date pair

answered Oct 1, 2013 at 17:57

Rajesh

3,7781 gold badge26 silver badges33 bronze badges

Comments

Baby Groot · Accepted Answer · 2013-11-23 07:57:04Z

0

$("button").click(function () {

$.getJSON("users.json", function (data) {



for (i in data)
{

for (k in data[i]) {
               alert(data[i][k]);
            }


});

});

edited Nov 23, 2013 at 7:57

Baby Groot

4,27939 gold badges55 silver badges70 bronze badges

answered Nov 23, 2013 at 7:35

Niaz Morshed

1

Comments

Niaz Morshed · Accepted Answer · 2013-11-24 07:54:11Z

0

$.ajax({
    type:'POST',
   url:'Default.aspx/GetPro',
  data:"{Pid:'"+ faram+"'}",
 contentType: 'application/json; charset=utf-8',
  dataType: 'json',
 async: true,
cache: false,

success: function(msg) {
 alert("{Pid:'"+ faram+"'}");
var orders =msg;
 if (orders.length > 0) {
test(orders);
   }
 else {
  alert("No Record Found");
   }
 },
error: function(xhr, textStatus, errorThrown) {
            alert(xhr.status);
              alert(errorThrown);
              alert(xhr.responseText);
        }

});

function test(data)
{

for (i in data)
          {
//ProductName Is Property Field Of c# Object
 alert(data[i]['ProductName'])
}



 }

answered Nov 24, 2013 at 7:54

Niaz Morshed

1

Collectives™ on Stack Overflow

Load JSON Data Using jQuery AJAX

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related