谷歌的融合表 - 访问数据和插入数据的android [英] Google Fusion Tables- access data and insert data from android

问题描述

我试图访​​问我的谷歌融合的一个表从我的Andr​​oid应用程序。我有几个疑问我想clearify（一些问题以及）：

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):

1. 我试着查询公共表之一在浏览器中使用这个URL直接（测试）：<一href=\"https://www.google.com/fusiontables/api/query?sql=SELECT%20%2a%20FROM%201W-rjFNnEYYsfJiN2vR8m09XwGQqMQkBHbmRwpQ\" rel=\"nofollow\">https://www.google.com/fusiontables/api/query?sql=SELECT%20*%20FROM%201W-rjFNnEYYsfJiN2vR8m09XwGQqMQkBHbmRwpQ并没有面对问题。现在，我要选择那些在它字符内 U 所有状态。 （CHANGE）在这第一份工作是先选择国家的名称。我尝试这样做： <$c$c>https://www.google.com/fusiontables/api/query?sql=SELECT%20State/UT%20$c$c,India/State/Union%20Territory%20#%20FROM%201W-rjFNnEYYsfJiN2vR8m09XwGQqMQkBHbmRwpQ - 我停留在这一点上。一些机构可以请帮助。这是一个公开的数据可以在这里观看 。为此，我已经看过开发人员文件查询融合表并的开发人员指南查询融合表

1. 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 u in 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

我失去了对如何在我的Andr​​oid端访问这些数据，并在其中插入值。我必须给公众许可，我的表？我已经看过开发文档融合表的。我一定要做出它的REST客户端，做这样的说法？

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.

在请求数量增加了限制，会发生什么？另外，如果我创建一个使用API​​密钥的应用程序，并通过每个提出申请，或命中总数的用户点击次数算？此外，什么都是收费的，如果一个人希望增加限制？

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?

在这方面的任何链接或 code 是高度AP preciated。

Any link or code in this regard is highly appreciated.

感谢

推荐答案

如果你想有一个简单的方法来测试我建议使用的谷歌浏览器的API为Fusion Tables的的。

If you want a simple way to test the API I recommend to use the Google API Explorer for Fusion Tables.

1. 如果您有空格的列名，你必须使用引号。结果
   - > <一个href=\"https://developers.google.com/apis-explorer/#p/fusiontables/v1/fusiontables.query.sql?sql=SELECT%20%27State%252FUT%20$c$c%27%252C%20%27India%252FState%252FUnion%20Territory%20%2523%27%20FROM%201W-rjFNnEYYsfJiN2vR8m09XwGQqMQkBHbmRwpQ&_h=4&\"相对=nofollow>请参见API探险这个例子。

SELECT 'State/UT Code', 'India/State/Union Territory #' FROM 1W-rjFNnEYYsfJiN2vR8m09XwGQqMQkBHbmRwpQ

这可能是最容易使用的现有 Java客户端的谷歌API （也有其他图书馆提供 ）。检查他们的 Java示例有关Fusion Tables 来的想法如何使用它。

It's probably the easiest to use the already existing Java client for the Google API (there are also other libraries available). Check their Java example for Fusion Tables to get the idea how to use it.

您必须使用OAuth验证自己（见的OAuth指南安装的应用程序）。上述 Java库也有OAuth的支持。

You have to use OAuth to authenticate yourself (see the OAUth guide for "Installed Applications"). The above mentioned Java library also has OAuth support.

我已经回答了这一项就另一个问题。

这篇关于谷歌的融合表 - 访问数据和插入数据的android的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！