[visualization-api] Reading a CSV or JSON Formatted DATA FILE into the HTML5-based Chart instead of Embedding it into the CODE?

[Lee Deneault]

Dear Google Groups,

Instead of *EMBEDDING* the following *DATA*, seen below, into *HTML5 Code*
...

function drawChart() {
var data = google.visualization.arrayToDataTable([
['Year', 'Sales', 'Expenses'],
['2004', 1000, 400],
['2005', 1170, 460],
['2006', 660, 1120],
['2007', 1030, 540]
]);


I would like to be able to actually *READ* this very same data from either a *CSV *or a *JSON *formatted *DATA FILE*!

Needless to say, any insight would be *GREATLY* appreciated!

Thanks, in advance, for your time and consideration!

Best Regards,

LEE

['Simon Roberts' via Google Visualization API]

Hello Lee,

Maybe something like this -

$(document).ready(function () {

$.ajax({
url: "/Reporting/LeaveList",
data: "",
dataType: "json",
type: "POST",
contentType: "application/json; chartset=utf-8",
success: function (data) {
chartData = data;
},
error: function () {
alert("Error loading data! Please try again.");
}
}).done(function () {
// after complete loading data
google.setOnLoadCallback(drawChart);
drawChart();
});
});

Post by Lee Deneault
Dear Google Groups,
Instead of *EMBEDDING* the following *DATA*, seen below, into *HTML5 Code*
...
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Year', 'Sales', 'Expenses'],
['2004', 1000, 400],
['2005', 1170, 460],
['2006', 660, 1120],
['2007', 1030, 540]
]);
I would like to be able to actually *READ* this very same data from either a *CSV *or a *JSON *formatted *DATA FILE*!
Needless to say, any insight would be *GREATLY* appreciated!
Thanks, in advance, for your time and consideration!
Best Regards,
LEE