Google Fusion Tables API
Written by Kay Ewbank   
Thursday, 28 June 2012

Google has announced the public availability of its new Fusion Tables API and at the same has begun a six-month deprecation period for the SQL API. So developers need to start to move over to Fusion Tables soon.

Fusion Tables is a data visualization web application that you can use to work with large data tables to extract meaningful information.

Fusion Tables lets you store, share, query, and visualize data tables. It has a REST API that you can use to manage tables, and a query facility that can be used to manage data rows (insert/update/delete), and query the table for all rows that match spatial or data conditions.

The results of queries can be CSV or JSON, or you can use them as the source for apps based on the Google Maps API or Google Chart Tools. Data that can be mapped in Fusion Tables can also be a layer on a Google Map:

fusion1

 

and it can also be a data source for Google Chart Tools:

 

fusioneg

 

Until now, developers have worked with Fusion Tables using Google’s SQL API. This has now been deprecated (June 26, 2012) and will cease to be available in six months, so you’ll need to move any apps you’ve created using the SQL API to Fusion Tables API.

The new API does everything the existing SQL API does, and adds the ability to read and modify table and column metadata. Fusion Tables API is also integrated with the Google APIs console so you can manage all your Google APIs in one place and take advantage of built-in reporting and authentication features.

Migrating to the new API is pretty simple; you turn on Fusion Tables in the APIs Console, update the URL endpoint in your application, remove numeric table IDs from your code, add any additional query parameters to the requests, and update the OAuth scope.

There are tutorials showing how to use Fusion Tables and even a "live" fusion table for you to "play around in" on Goggle Drive.

 fusiontableslogoMore Information

Google Fusion Tables

Developers Guide

Related Articles

More Spring Cleaning from Google

Google Drive API - an Opportunity?

 

blog comments powered by Disqus

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

 

Banner


Cybercrime From OU and BBC
01/11/2014

The Open University and the BBC have teamed up in a 6-part TV series about cybercrime. It starts today, Saturday, November 1 (repeated tomorrow) and can be viewed worldwide on BBC World News.



AngularJS 2.0 Is Radically Different
05/11/2014

The AngularJS team has given a view of the future of the framework and many programmers are finding it unacceptable. An almost complete break with the past means that many are working on projects that [ ... ]


More News

Last Updated ( Thursday, 28 June 2012 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.