Data Table Stuck in Processing Screen

broadway69

First off, wow! What a wonderful idea and incredibly executed open source API. Now if only I could learn how to use it effectively! :D

In a Sandbox I was able to combine Data Tables with my Sugar CRM Rest Classes to populate direct calls and all was good. I've moved on to my ultimate goal of packaging a comprehensive integration solution for Joomla to display Sugar CRM data using Data Tables. Here's where the problem start.

My table and styling load with proper columns, but gets stuck at the processing screen. Firebug has the below error which leads me to believe I failed to properly configure an element as the callback is reaching a null location. In addition, I'm a little fuzzy on what "type" of call I should be making. My Sugar REST class packages the return data in arrays and converts to JSON (this worked on stand alone so I assume this is fine) but I've toyed with using sAjaxSource with bServerSide and loading the data tables directly into aaData. Two examples below:

The json data is being load in by a method locally. Any suggestions would be appreciated and direction on how I should approach the loading of data if a local class method will be parsing and serving it.

And again, stellar jquery api!

[code]
$(document).ready(function(){
$('#" . $name . "').dataTable({
'bJQueryUI' : true,
'sPaginationType' : 'full_numbers',
'bProcessing' : true,
'bServerSide' : true,
'sAjaxSource' : " . self::prepareDataTablesJSON() . ",
'aoColumns' : " . self::prepareColumnsData() . "
});
});
[/code]

[code]
$(document).ready(function(){
$('#" . $name . "').dataTable({
'bJQueryUI' : true,
'bProcessing' : true,
'aaData' : " . json_encode(self::prepareDataJSON()) . ",
'aoColumns' : [{"iTitle" : "Name", "mData" : "rest_name"}, {"iTitle" : "Title", "mData" : "rest_title"}]
});
});
[/code]

Here is my FireBug 404 error, I can't help put feel I need to alter the path but unaware how it is being assigned and where it need to go!

[code]http://localhost/joomla25/administrator/null?sEcho=1&iColumns=4&sColumns=&iDisplayStart=0&iDisplayLength=10&mDataProp_0=id&mDataProp_1=name&mDataProp_2=account_type&mDataProp_3=dki_chapter_c&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&_=1345478341095 404 (Not Found) [/code]