Error 2601 in fusion table

[shairyl srivastava]

hello programmers,

I am trying to carry out a simple insert query from app inventor( blocks attached). 

But when I run the app, I get:

Error in SendQuery

Errror 2601: Fusion tables returned an error. the query was: INSERT INTO 1sagm8DG6L0M85eHhw_wyg2Pk4GOCXA5DRO4OQW0G(Book, Comments)VALUES (harry potter, Nice book). The response was: 400 Bad Request {"error":"invalid_grant"}

I have read the pizza example and the queries in the google help page but I don't see any errors. I cannot find any mistake in the blocks, see if you guys can help me.

[John Lo]

Apparently the Pizza Party example is not working anymore for some reason nobody knows at this moment, I also tried exactly the same procedure as the tutorial but didnt work at all. I also read several threads about Unauthorized invalid credentials but none of them were useful, if the problems resides on the google side this forum will not deliver a solution.
Hopefully somebody could provide a good hint on this. 
John

[Taifun]

there is a syntax error in your sql statement, values need to be quotified, you can learn how to work with fusiontables in the Pizza Party tutorial Pizza Party with Fusion Tables for App Inventor 2

see also 

Frequently Made Errors with Fusiontables and how to fix them

also, and this is, what John is talking about,  for some devices, the api key method unfortunately does not work anymore, which results in "error 401 Unauthorized Invalid Credentials"

MIT is aware of that issue, see also here https://groups.google.com/d/msg/mitappinventortest/zasQRzYA4H0/_dqtmT4DCgAJ 

Meanwhile you can use the service account method instead

How to use the Service account option to connect to a  Fusiontable

Taifun

---

Trying to push the limits of App Inventor! Snippets and Tutorials from Pura Vida Apps by Taifun.