jQuery Grid Plugin - jqGrid

Any help would be appreciated, I am new to javascript / jsGrid / ect... and I am having a hard time understanding what I am doing wrong.  I installed the jqGrid from nuget, so I am thinking my dependencies are ok.

Error in Javascript console in chrome:

1. Uncaught TypeError: Cannot read property '0' of undefined jquery.jqGrid.min.js:15
   1. b.extend.getAccessorjquery.jqGrid.min.js:15
   2. Vjquery.jqGrid.min.js:61
   3. b.ajax.b.extend.successjquery.jqGrid.min.js:74
   4. firejquery-1.9.1.js:1037
   5. self.fireWithjquery-1.9.1.js:1148
   6. donejquery-1.9.1.js:8074
   7. callbackjquery-1.9.1.js:8598

Data coming back from WebApi Service:

{"page":1,"records":186,"rows":[{"GUID_ID":"bb71e699-e4a8-46ae-9d9d-0155b089d16d","name":"Mary Smith ","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":3,"loanbalance":6400000.0,"numofdeposits":4,"depositbalance":50000.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":9,"ownedby":"2fe52fc6-49d6-4b49-be0b-80b58abed149","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"27795807-034f-4948-8537-0306bd4dc6c4","moddate":"2013-09-10T06:38:13.033","createddate":"2010-12-20T20:20:55.197","netincome":-34995.2030790035,"relationshiproe":-0.0826356891034183,"avgbalance":6222616.52058944,"monthsuntilfirstrenewal":"2010-12-20T20:20:55.197","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"4974ab8b-e5a7-4d7e-8e86-01b4f9c5b677","name":"Thursday Demo","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":2,"loanbalance":600000.0,"numofdeposits":2,"depositbalance":150000.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":4,"ownedby":"bac9367d-1761-4ad0-900e-ffc3123c13af","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"bac9367d-1761-4ad0-900e-ffc3123c13af","moddate":"2013-09-10T06:38:05.97","createddate":"2011-07-21T16:45:38.497","netincome":11290.8619380034,"relationshiproe":0.245970986036218,"avgbalance":549999.680549255,"monthsuntilfirstrenewal":"2011-07-21T16:45:38.497","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"4fa6b7eb-6426-4969-8b78-0335bf34d7ce","name":"test","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":3,"loanbalance":1300000.0,"numofdeposits":0,"depositbalance":0.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":3,"ownedby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","moddate":"2013-09-10T06:38:06.003","createddate":"2011-04-14T15:04:12.94","netincome":11800.9817801947,"relationshiproe":0.213878126899301,"avgbalance":764447.175305447,"monthsuntilfirstrenewal":"2011-04-14T15:04:12.94","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"d692992a-7f1b-4c67-818f-0606e974f667","name":"Standard Engineering","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":4,"loanbalance":850000.0,"numofdeposits":2,"depositbalance":8500.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":4,"ownedby":"a5bd83ab-1008-4d35-8d54-00cb918449c2","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"a5bd83ab-1008-4d35-8d54-00cb918449c2","moddate":"2013-09-10T06:38:06.72","createddate":"2011-04-06T16:05:16.14","netincome":7663.85936080325,"relationshiproe":0.155542750762765,"avgbalance":655391.451532196,"monthsuntilfirstrenewal":"2011-04-06T16:05:16.14","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"785033b3-ace5-4ea5-a9fb-0727c93c6bfa","name":"Allgood Exterminators ","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":4,"loanbalance":11450000.0,"numofdeposits":1,"depositbalance":0.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":10,"ownedby":"bac9367d-1761-4ad0-900e-ffc3123c13af","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"bac9367d-1761-4ad0-900e-ffc3123c13af","moddate":"2013-09-10T06:38:06.363","createddate":"2011-01-21T22:14:34.357","netincome":116105.472412697,"relationshiproe":0.219077563978398,"avgbalance":9224511.73693063,"monthsuntilfirstrenewal":"2011-01-21T22:14:34.357","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"91c12317-a03a-4f27-917a-08bda3d2f889","name":"March 1","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":1,"loanbalance":675000.0,"numofdeposits":2,"depositbalance":285000.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":6,"ownedby":"a5bd83ab-1008-4d35-8d54-00cb918449c2","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"a5bd83ab-1008-4d35-8d54-00cb918449c2","moddate":"2013-09-10T06:38:09.72","createddate":"2011-03-01T19:12:45.633","netincome":9255.56920256222,"relationshiproe":0.18088674922998,"avgbalance":590692.040319316,"monthsuntilfirstrenewal":"2011-03-01T19:12:45.633","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"833d1bb9-7275-4f85-bf2f-095f1c6de3f3","name":"June 15","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":0,"loanbalance":0.0,"numofdeposits":0,"depositbalance":0.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":0,"ownedby":"0553dfe6-9738-4d78-b013-11919f55529f","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"0553dfe6-9738-4d78-b013-11919f55529f","moddate":"2013-09-10T06:38:06.66","createddate":"2011-06-15T12:46:25.07","netincome":0.0,"relationshiproe":0.0,"avgbalance":0.0,"monthsuntilfirstrenewal":"2011-06-15T12:46:25.07","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"5e22e787-1d2f-4919-946f-0a3d41c11367","name":"Min ROE Test","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":1,"loanbalance":500000.0,"numofdeposits":0,"depositbalance":0.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":3,"ownedby":"bac9367d-1761-4ad0-900e-ffc3123c13af","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"bac9367d-1761-4ad0-900e-ffc3123c13af","moddate":"2013-09-10T06:38:08.143","createddate":"2011-02-15T23:03:39.597","netincome":3338.79228473595,"relationshiproe":0.157673689505618,"avgbalance":265787.608013217,"monthsuntilfirstrenewal":"2011-02-15T23:03:39.597","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"9925b3b3-e002-4246-ac3b-0ca427109883","name":"ProfitStars","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":1,"loanbalance":750000.0,"numofdeposits":1,"depositbalance":150000.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":3,"ownedby":"bac9367d-1761-4ad0-900e-ffc3123c13af","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"bac9367d-1761-4ad0-900e-ffc3123c13af","moddate":"2013-09-10T06:38:11.94","createddate":"2011-06-10T19:38:49.987","netincome":16836.6252353928,"relationshiproe":0.279435666943372,"avgbalance":702982.964431637,"monthsuntilfirstrenewal":"2011-06-10T19:38:49.987","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"b5d8351b-8802-4a44-9429-0df6e7801619","name":"PEC Test","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":1,"loanbalance":500000.0,"numofdeposits":1,"depositbalance":150000.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":3,"ownedby":"bac9367d-1761-4ad0-900e-ffc3123c13af","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"bac9367d-1761-4ad0-900e-ffc3123c13af","moddate":"2013-09-10T06:38:10.533","createddate":"2011-03-09T14:05:24.19","netincome":7215.95044727253,"relationshiproe":0.174277910681859,"avgbalance":461490.806371888,"monthsuntilfirstrenewal":"2011-03-09T14:05:24.19","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"ac22aab7-936d-497a-8b33-1106914652bd","name":"Goswami Line","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":5,"loanbalance":5446000.0,"numofdeposits":2,"depositbalance":1481000.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":5,"ownedby":"0553dfe6-9738-4d78-b013-11919f55529f","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"0553dfe6-9738-4d78-b013-11919f55529f","moddate":"2013-09-10T06:38:17.703","createddate":"2011-01-27T21:24:26.987","netincome":17895.5922917388,"relationshiproe":0.0,"avgbalance":0.0,"monthsuntilfirstrenewal":"2011-01-27T21:24:26.987","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"492efdc5-c1e6-4f50-9e60-1250f675c3d7","name":"1st NC","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":2,"loanbalance":700000.0,"numofdeposits":1,"depositbalance":150000.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":3,"ownedby":"bac9367d-1761-4ad0-900e-ffc3123c13af","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"bac9367d-1761-4ad0-900e-ffc3123c13af","moddate":"2013-09-10T06:38:12.503","createddate":"2011-05-17T18:18:46.227","netincome":10052.3617210072,"relationshiproe":0.196777834136715,"avgbalance":579679.395916204,"monthsuntilfirstrenewal":"2011-05-17T18:18:46.227","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"4f2504dc-4c8f-48d5-8df8-16c2e3d4aced","name":"XYZ","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":0,"loanbalance":0.0,"numofdeposits":0,"depositbalance":0.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":0,"ownedby":"27795807-034f-4948-8537-0306bd4dc6c4","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"27795807-034f-4948-8537-0306bd4dc6c4","moddate":"2013-09-10T06:38:09.91","createddate":"2010-12-17T19:38:22.07","netincome":0.0,"relationshiproe":0.0,"avgbalance":0.0,"monthsuntilfirstrenewal":"2010-12-17T19:38:22.07","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"8527bd70-9944-484e-ace0-1d09e3902e44","name":"Minimum","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":1,"loanbalance":7250000.0,"numofdeposits":0,"depositbalance":0.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":8,"ownedby":"28fb8045-5e34-4c1a-84a0-ef734a32655e","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"28fb8045-5e34-4c1a-84a0-ef734a32655e","moddate":"2013-09-10T06:38:11.72","createddate":"2011-01-16T20:24:58.44","netincome":17162.0294019503,"relationshiproe":0.17579234726123,"avgbalance":1811490.42152192,"monthsuntilfirstrenewal":"2011-01-16T20:24:58.44","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false},{"GUID_ID":"adb3413a-d370-426f-8415-20a468bd66f4","name":"LOC","briefdescription":null,"fulldescription":"","autorenewloc":0,"numofloans":0,"loanbalance":0.0,"numofdeposits":0,"depositbalance":0.0,"numofotherrels":0,"otherrelbalance":0.0,"yearsremaining":0,"ownedby":"bac9367d-1761-4ad0-900e-ffc3123c13af","modby":"b9071253-45f6-4dbc-baab-0fd72ad36c73","createdby":"bac9367d-1761-4ad0-900e-ffc3123c13af","moddate":"2013-09-10T06:38:13.55","createddate":"2011-03-11T16:55:22.67","netincome":0.0,"relationshiproe":0.0,"avgbalance":0.0,"monthsuntilfirstrenewal":"2011-03-11T16:55:22.67","RequiresReview":false,"Deleted":false,"ExtIDList":"","OverrideOfficer":false}],"total":13.0}

grid.js

var API_URL = 'api/RelationshipGridjq';

$(document).ready(function ()

{

$("#aGrid").jqGrid({

url: API_URL,

datatype: "json",

// mtype: 'GET',

//jsonReader: { repeatitems: false, id: "Id" },

colNames: ['Relationship Name', 'Loan Officer', 'Net Income', 'ROE', 'Current Loan Balance', 'Loans', 'Loan Total', 'Deposits', 'Deposits Total', 'Years Remaining', 'Description', 'Core System IDs'],

colModel: [

{ name: 'name' ,index: 'name' ,width:200 },

{ name: 'ownedby' ,index: 'ownedby' ,width:200 },

{ name: 'netincome' ,index: 'netincome' ,width:150 },

{ name: 'relationshiproe' ,index: 'relationshiproe',width:120 },

{ name: 'avgbalance' ,index: 'avgbalance' ,width:200 },

{ name: 'numofloans' ,index: 'numofloans' ,width:80 },

{ name: 'loanbalance' ,index: 'loanbalance' ,width:150 },

{ name: 'numofdeposits' ,index: 'numofdeposits' ,width:100 },

{ name: 'depositbalance' ,index: 'depositbalance' ,width:150 },

{ name: 'yearsremaining' ,index: 'yearsremaining' ,width:150 },

{ name: 'fulldescription' ,index: 'fulldescription',width:200 },

{ name: 'ExtIDList' ,index: 'ExtIDList' ,width:150 }

],

rowNum: 15,

rowList: [10, 20, 50, 100],

pager: '#aGridPager',

sortname: 'name',

viewrecords: true,

sortorder:'desc',

caption: 'List of Relationships',

error: function (x, e) {

alert(x.readyState + " " + x.status + " " + e.msg);

}

});

$("#aGrid").jqGrid('navGrid', '#aGridPager', { edit: false, add: false, del: false });

})

cshtml:

@{

ViewBag.Title = "jq Grid";

}

<h2>jqGrid</h2>

@*jqGrid*@

@*@Styles.Render("~/Content/themes/base/css", "~/Content/css")*@

@*<link href="@Url.Content("~/Content/jquery.jqGrid/ui.jqgrid.css")" rel="stylesheet" type="text/css" />*@

<script src="@Url.Content("~/Scripts/jquery-1.9.1.js")"></script>

<script src="@Url.Content("~/Scripts/jquery-ui-1.10.3.js")"></script>

<script src="@Url.Content("~/Scripts/i18n/grid.locale-en.js")"></script>

<script src="@Url.Content("~/Scripts/jquery.jqGrid.min.js")"></script>

<script src="@Url.Content("~/Scripts/jqGrid/grid.js")"></script>

<table id="aGrid"></table>

<div id="aGridPager"></div>