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?

 

pico book

 

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


Konrad Zuse Born On This Day In 1910
22/06/2025

Today marks the 115th anniversary of Konrad Zuse. Although his name may not be familiar in English-speaking circles, in Germany he is known as "der Vater des Computers". He does indeed have a strong c [ ... ]



Windows 11 Overtakes Windows 10 - But Not In Europe
08/07/2025

With the end of support of Windows 10 just three months away, Windows 11 has finally edged ahead of Windows 10 in terms of  Desktop Windows Version Market Share on a Worldwide Basis. In Europe, h [ ... ]


More News

Last Updated ( Thursday, 28 June 2012 )