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?

 

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

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


Five Tips for Managing Hybrid Development Teams
08/03/2024

Managing hybrid development teams can be challenging, but  can also be a rewarding endeavor. Here are some tips to follow to ensure success. 



Couchbase's Coding Assistant Goes GA
11/03/2024

Capella iQ, the AI coding assistant for developers that makes interacting with Couchbase using natural language possible, has gone from private beta to being generally available.


More News

Last Updated ( Thursday, 28 June 2012 )