getJSON only getting first element of returned array

Question

I have a api controller function that returns an array of objects. The following is how I call my function and an example of what happens:

$.getJSON("/api/mycontroller/myfunc/?id=" + id, function (data) {
   data[0].field1  <- correct value here
   data[0].field2  <- correct value here

   data[1].field1  <- null
   data[1].field2  <- null
}

The first element contains the correct values as illustrated but all other elements are null. data.length returns the correct size of the array and I have verified that my controller is returning the values I anticipate. Am I missing something here???

UPDATE: Here is my controller method:

public data[] myfunc(long id)
{
     return db.MyTable.Where(x => x.ID == id).ToArray();
}

As mentioned I have verified that the array being returned contains the correct values.

JSON response is this:

Object { $id="1",  Referral={...},  MeetingID=1,  more...}
$id     "1"
Referral    Object { $id="2",  IntakeMember={...},  Meetings=[3],  more...}
MeetingID   1
MeetingDate "2015-01-01T00:00:00"
Notes   "test1"
ReferralID  22

Object { $ref="16"}
$ref    "16"

Object { $ref="17"}
$ref    "17"

So as you can see elements 2 and 3 just have this "ref" value in them...not sure why??

UPDATE #2:

Tried $.get rather than $.getJSON without success, same issue. I also tried making the following changes to the controller:

MyData[] data = db.MyTable.Where(x => x.ID == id).ToArray();
JsonResult jsonResult = new JsonResult
{
    Data = data,
    JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
return jsonResult.Data;

I still experience the same issue.

@mattfetz more importantly an example of the JSON response to the get method — vogomatix
– vogomatix, Commented Sep 2, 2015 at 17:40
Ok now go to your web browsers web tools and check the network response from this ajax call. You will be able to see the entire JSON response here and determine if you are getting the right data. — mattfetz
– mattfetz, Commented Sep 2, 2015 at 17:54

user3559349 · Accepted Answer · 2015-09-02 22:53:21Z

1

$.getJSON() expects the returned data to be JSON. Change your controller method to return JSON

public JsonResult myfunc(long id)
{
     var data = db.MyTable.Where(x => x.ID == id);
     return Json(data, JsonRequestBehavior.AllowGet);
}

answered Sep 2, 2015 at 22:53

user3559349

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

3 Comments

mgrenier Over a year ago

it appears Json is a member of the Controller library, however my function is in an ApiController...can I still use it? I get a not recognized error

user3559349 Over a year ago

Dammit - just realized its WebAPI. I guessing what your returning is XML, not JSON, so you can first try changing $.getJSON() to just $.get(). Alternatively you can look at the answers here

mgrenier Over a year ago

I attempted your suggestions without success, I updated my original post to reflect what I tried.

mgrenier · Accepted Answer · 2015-09-04 12:44:12Z

1

For some reason my problem got resolved when I created a view in my database and used that to return data rather than directly querying the table it resides in. I put this hear in case anyone experiences an issue similar to mine but if anyone who know why this happened I would be interested to hear...please comment on this answer.

answered Sep 4, 2015 at 12:44

mgrenier

1,4673 gold badges23 silver badges46 bronze badges

1 Comment

Matt Over a year ago

I had a similar problem but fixed it by manually looping through my LINQ to Entities resultset and creating new objects. I do not know what the problem was, either, but I wasn't about to alter my database schema for it...

Collectives™ on Stack Overflow

getJSON only getting first element of returned array

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related