I have this code that get the data from SharePoint using ajax, and the datatable plugin creates the table.
function LoadAIP(state){
var call = $.ajax({
url:"https://xxxx/xxxx//_api/web/lists/getByTitle('Consolidated%20LC%20Report')/items()?
$select=ROCode,AIP,NotificationDate",
type: "GET",
dataType: "json",
headers: {
Accept: "application/json;odata=verbose"}});
call.done(function (data,textStatus, jqXHR){
$('#example').dataTable( {
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"aaData": data.d.results,
"aoColumns": [
{ "mData": "ROCode" },
{ "mData": "AIP" },
{ "mData": "NotificationDate" }],"bRetrieve": true,
"sDom": '<"H"Tfr>t<"F"ip>',
"oTableTools": {
"aButtons": [ "xls"],
"sSwfPath": ../js/datatables/TableTools/media/swf/copy_csv_xls_pdf.swf",
"bFilter": true}} );});
call.fail(function (jqXHR,textStatus,errorThrown){
alert("Error retrieving Tasks: " + jqXHR.responseText);});}
Is there a way to represent this data using Google Visualization API? I have been reading the documentation, but I haven't found there exactly what I need. thanks!