Updating a row in a Google Fusion Table

Question

I am trying to update a row in a Google Fusion table as per the instructions on this page with a URL of the following form:

https://www.google.com/fusiontables/api/query/?sql=UPDATE<TABLEID>SET<COLUMN NAME>=<NEW VALUE>WHERE ROWID=<ROWIDVALUE>

When I enter this into a browser I get a 'File Not Found' message. Any suggestions as to what I might be doing wrong would be appreciated.

There seems to be a general problem with the "old" API. The Trusted Tester API works, though. — Odi, May 18 '12 at 21:02

score 4 · Answer 1 · edited May 23 '17 at 12:25

4

Need oauth2 to create token. See details here and here
Then simply add that token to URL

https://www.google.com/fusiontables/api/query/?sql=UPDATE<TABLEID>SET<COLUMN NAME>=<NEW VALUE>WHERE ROWID=<ROWIDVALUE>&access_token=<ACCESS TOKEN>

edited May 23 '17 at 12:25

Community

1
1

answered Jun 25 '12 at 20:52

Cody Tookode

862
12
22

Thanks for pointing to actual examples and direct guides. I'm tired of being pointed in the direction of reading the entire documentation on something, that's not an answer to the question. It certainly provides the important context and should be read eventually but I post questions because the guide is not clear to me. – ericjam Dec 23 '12 at 23:10

score 0 · Answer 2 · answered May 22 '12 at 22:06

In order to update a table, either using the old or the new API, you need to send an authorization header along with the request. More information about authorization can be found here:

https://developers.google.com/fusiontables/docs/developers_guide#Authentication

Updating a row in a Google Fusion Table

2 Answers2