Create a Fusion Table
function createFusionTable() {
var table = FusionTables.newTable();
table.name = 'My sales table';
table.columns = [
createColumn('Product', 'STRING'),
createColumn('Date', 'DATETIME'),
createColumn('Sales', 'NUMBER')
];
table.isExportable = true;
var newTable = FusionTables.Table.insert(table);
Logger.log('Table with ID = %s and name = %s was created.',
newTable.tableId, newTable.name);
}
Insert data into a Fusion Table
function insertDataIntoFusionTable() {
// See https://developers.google.com/chart/interactive/docs/fusiontables for
// details on how to obtain your Google Fusion Table's ID from its URL.
var tableId = 'INSERT_FUSION_TABLE_ID_HERE';
// Prepare the data to insert into the table. This should be in CSV format,
// and should match your table's schema.
var data = Utilities.newBlob('Cake,2014-01-01,25\nCake,2014-01-02,35\n');
data.setContentType('application/octet-stream');
FusionTables.Table.importRows(tableId, data);
Logger.log('Data imported successfully into Fusion Table.');
}
Query data from Fusion Table
function queryDataFromFusionTable() {
// See https://developers.google.com/chart/interactive/docs/fusiontables for
// details on how to obtain your Google Fusion Table's ID from its URL.
var tableId = 'INSERT_FUSION_TABLE_ID_HERE';
var results = FusionTables.Query.sql('Select Date, Sales from ' + tableId +
" where Product = 'Cake'");
Logger.log(results.columns.join(','));
for (var i = 0; i < results.rows.length; i++) {
Logger.log(results.rows[i].join(','));
}
}