jQuery getJSON with .NET MVC not working

Question

I have setup a getJSON call when page loads in my .NET MVC app like this:

$(document).ready(function(){
   $.getJSON("/Administrator/GetAllUsers", function (res) {

            // getting internal server error here...
        });

});

And the action looks like this:

  [HttpGet]
    [ActionName("GetAllUsers")]
    public string GetAllUsers()
    {
        return new JavaScriptSerializer().Serialize(ctx.zsp_select_allusers().ToList());
    }

I'm getting this error:

500 (Internal Server Error)

What am I doing wrong here???

return Json(ctx.zsp_select_allusers(), JsonRequestBehavior.AllowGet); — user3559349
– user3559349, Commented Apr 5, 2017 at 11:25
Remove the slash / before Administrator/GetAllUsers and check. Your return type should be JsonReturn — Basanta Matia
– Basanta Matia, Commented Apr 5, 2017 at 11:26
And its needs to be public ActionResult GetAllUsers() or public JsonResult GetAllUsers() — user3559349
– user3559349, Commented Apr 5, 2017 at 11:27
There is no need for .ToList() (its being serialized, so therefore the collection is being iterated) — user3559349
– user3559349, Commented Apr 5, 2017 at 11:30

user7819643 · Accepted Answer · 2017-04-05 11:36:45Z

1

In MVC, json result only returned if you make post request to it for some security purposes, until and unless you explicitly specify JsonRequestBehavior.AllowGet, also change your return type

[HttpGet]
    [ActionName("GetAllUsers")]
    public JsonResult GetAllUsers()
    {
        return Json(ctx.zsp_select_allusers(), JsonRequestBehavior.AllowGet);
    }

answered Apr 5, 2017 at 11:36

user7819643

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

2 Comments

user7819643 Over a year ago

It's silly but try to remove [HttpGet] and [ActionName("GetAllUsers")]

user7819643 Over a year ago

If still you get the error, edit your question and paste code of your controller.

Basanta Matia · Accepted Answer · 2017-04-05 11:59:46Z

1

Change your return type in method and return Json, like bellow,

[HttpGet]
[ActionName("GetAllUsers")]
public ActionResult GetAllUsers()
{
    var data = ctx.zsp_select_allusers().ToList();
    return Json(data, JsonRequestBehavior.AllowGet);
}

As you have mentioned in your comment, you are still getting 500 error. I think this controller have [Authorize] attribute and you are calling this method without login. In this case you can use [AllowAnonymous] attribute in GetAllUsers() to access the method.

edited Apr 5, 2017 at 11:59

answered Apr 5, 2017 at 11:33

Basanta Matia

1,5904 gold badges15 silver badges29 bronze badges

Comments

Asif Raza · Accepted Answer · 2017-04-05 12:47:46Z

1

try it

$.getJSON('@Url.Action("GetAllUsers", "Administrator")', function (res)   {

            alert(res);
        });

 [HttpGet]
    public ActionResult GetAllUsers( ) {

          //get the data from db , then send it
          //i'm passing dummy text 'got it'

        return Json("got it", JsonRequestBehavior.AllowGet);
    }

edited Apr 5, 2017 at 12:47

answered Apr 5, 2017 at 12:13

Asif Raza

1,0297 silver badges14 bronze badges

Collectives™ on Stack Overflow

jQuery getJSON with .NET MVC not working

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related