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.
Hossein,
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
Marc, Please post your question in AppToMarket forum HERE so that others could also participate.
Thanks,
Hossein.