I am trying to access one of my google fusion tables from my android application. I have a few doubts I would like to clearify (few problems as well):
I tried to query one of the public tables (for test) using this direct URL in my browser: https://www.google.com/fusiontables/api/query?sql=SELECT%20*%20FROM%201W-rjFNnEYYsfJiN2vR8m09XwGQqMQkBHbmRwpQ and faced no problem. Now I want to select all states that have a charcter
uin it. (CHANGE) At this first job was to select names of states first. I tried this:
https://www.google.com/fusiontables/api/query?sql=SELECT%20State/UT%20Code,India/State/Union%20Territory%20#%20FROM%201W-rjFNnEYYsfJiN2vR8m09XwGQqMQkBHbmRwpQ– I am stuck at this point. Can some body please help. This is a public data and can be viewed here. For this I have already looked at developer docs for querying fusion tables and developer guide for querying fusion tables
I am lost on how to access this data at my android side and insert values in it. Do I have to give public permission to my table? I have looked at developer docs for fusion tables. Do I have to make a REST Client for it and do it that way?
Also, inserting data from my app is problem. I have not tried anything yet in this regard, but have searched a lot and have not found any thing useful. Any link in this regard would do.
What happens after number of request increases the limit? Also, if I create an application using an API key, does the number of hits per user of the application or total number of hits by the application count? Also, what are the charges if one wishes to to increase the limits?
Any link or code in this regard is highly appreciated.