Fusion Tables Service

Warning: The Fusion Tables API that this service enabled was deprecated on December 11, 2018. You can continue to use the advanced service until December 3, 2019, when the API will be fully shutdown. See the Fusion Tables help center for more details.

The Fusion Tables service allows you to use the Google Fusion Tables API in Apps Script. This API gives users the ability to store, share, and query their data tables.

Note: This is an advanced service that must be enabled before use.

Reference

For detailed information on this service, see the reference documentation for the Fusion Tables API. Like all advanced services in Apps Script, the Fusion Tables service uses the same objects, methods, and parameters as the public API.

To report issues and find other support, see the Fusion Tables support guide.

Sample code

The sample code below uses version 2 of the API.

List tables

This sample lists Fusion Tables that the user has access to.

advanced/fusionTables.gs

View on GitHub

/**
 * This sample lists Fusion Tables that the user has access to.
 */
function listTables() {
  var tables = FusionTables.Table.list();
  if (tables.items) {
    for (var i = 0; i < tables.items.length; i++) {
      var table = tables.items[i];
      Logger.log('Table with name "%s" and ID "%s" was found.',
                 table.name, table.tableId);
    }
  } else {
    Logger.log('No tables found.');
  }
}

Run query

This sample queries for the first 100 rows in the given Fusion Table and saves the results to a new spreadsheet.

advanced/fusionTables.gs

View on GitHub

/**
 * This sample queries for the first 100 rows in the given Fusion Table and
 * saves the results to a new spreadsheet.
 * @param {string} tableId The table ID.
 */
function runQuery(tableId) {
  var sql = 'SELECT * FROM ' + tableId + ' LIMIT 100';
  var result = FusionTables.Query.sqlGet(sql, {
    hdrs: false
  });
  if (result.rows) {
    var spreadsheet = SpreadsheetApp.create('Fusion Table Query Results');
    var sheet = spreadsheet.getActiveSheet();

    // Append the headers.
    sheet.appendRow(result.columns);

    // Append the results.
    sheet.getRange(2, 1, result.rows.length, result.columns.length)
        .setValues(result.rows);

    Logger.log('Query results spreadsheet created: %s',
        spreadsheet.getUrl());
  } else {
    Logger.log('No rows returned.');
  }
}