Handling data from Google fusiontables

06 Jun

Google Fusion Tables API supports a subset of the SQL querying language, including SELECT, INSERT, UPDATE, and DELETE statements, as well as additional statements for getting information about tables.

The API and sample queries can be found HERE

HERE is how to submit a SQL query to retrieve data from fusiontable.



Posted by on June 6, 2011 in Uncategorized


2 responses to “Handling data from Google fusiontables

  1. Marc

    July 7, 2011 at 2:09 am


    Thank you so much for all of your insight into Google Fusion Tables and particularly for your amazing tool to publish App Inventor Apps to the Android App market.

    I’m currently developing an App where I have quite a lot of masterdata in Google Fusion Tables. I manage to import it from Google Fusion Tables and store it in lists in App Inventor. One of the lists is extremely long, but I want to use the content of the list as input for a listpicker event. Of course, if I provide the raw list, the listpicker list is super long (and the user would be forced to scroll through all of the items on the cell phone). Quick question:
    1. How do I go about sorting this master list by starting Alphabet in App Inventor?
    2. How do I go about breaking this master list into sub lists with items starting with letter A, items starting with letter B, items starting with letter C, etc…. I would then want to have an intermediary screen which would give the user the option of either choosing to painfully scroll through all items or to pick by starting letter (which would greatly reduce the scrolling need after having picked the starting letter).

    Thanks in advance for your help. Greatly appreciated.

    Cheers, marc1i


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: