Fusion tables query shows an error always

[Yusuf Jk]

Hello there,

                   i am trying to create an inventory app with fusion tables. I have the api as well as the table id but i dont know what goes wrong and my query shows nothing but an error message. in the fusion tables db there are 3 columns ie. product, qty and price. a pic is attached below to understand what i want to do. please help me access the tables.

Thanks and regards

[Taifun]

remove WHERE in the condition and use single quotes instead of double quotes

what do you get in the fusiontable got result event?

Taifun

---

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

[Yusuf Jk]

I did but the result is still same "error"

[Taifun]

post again a screenshot of your relevant blocks and add a screenshot of the fusiontable got result event

also, what error exactly do you get?

see also 

Frequent Made Errors with Fusiontables and how to fix them

Taifun

[Yusuf Jk]

I have seen all your tutorials but cant find any solution please help

[Taifun]

which value do you get from the spinner?

did you download the rowids from the table first and then provide them in the spinner to be able to select one of them?

it would help to use Do it to see the condition of your statement

you said, you read all my tutorials, which means, you are familiar with Do it...

and: what error exactly do you get?

Taifun

[Yusuf Jk]

The size value. which is disabled, it enables when the specific item is selected and when i click the do option it processes the query in the ai companion app but the last label which i have kept to show the qty from the fusion tables only shows the text "Error" nothing apart from that. and nothing i have downloaded just the spinners are hidden. 

[Taifun]

as you can see from the screenshot, the query works

btw. it does not matter if you quotify the rowid or not...

probably you are using a non existing rowid or there does not exist the column Qty in your table?

note: column names are case sensitive...

however if I use a non existent column name, I get the error message 

400 Bad Request Invalid query: Column `x' does not exist

as you can see, "Do it" helps... you might want to provide a screenshot including Do it result...

Taifun

[Yusuf Jk]

please find the attached pic and help me figure out where have i made the blunder.

P.S my fusion table is kept private (if that is the problem idk)

[Yusuf Jk]

[Taifun]

please provide a screenshot incl Do it result of the join block

Taifun

[Yusuf Jk]

When i click on the do it option where you have mentioned it directly processes a request in the companion app and the result is "error" same thing :/

[Enis]

That tells me that the info you're getting back from your spinner is incorrect, and you're passing that incorrect info to the call to get rows...

[Taifun]

Right mouse click onto the join block, then select "Do it" should give you something else...
Remove the SendQuery block!
Taifun

[Ketaki Rao]

In addition to Taifun's pointer to use single quotes instead of double, I'd also suggest the following steps to narrow it down. I went through the FusionTable pain myself last week and found that both queries and permissions are quite tricky. In my experience, the Error result is generally due to bad permissions.

For debug, I'd pick a simpler query just to get the access part working, and then you can always add back the list selection. So for e.g. just make the conditions block "Qty=1". Totally optional, of course, but it helped me stay focused on one issue at a time :)

For the permissions. I see you are using the API Key. Is this the Global API key in Developers Console or are you trying to authenticate users? I was unable to get the Global API key working without making the FusionTable Public, something I didn't want to do. If you don't need to authenticate users, I find the Service Account Authentication method to be a cleaner option. 

https://developers.google.com/accounts/docs/OAuth2ServiceAccount

Here are the steps I followed to get it working.

- Developers Console: create a Service Account and download the generated key.

- AppInventor: Upload that key and set up the FusionTable to be accessed through the ServiceAccount. I've attached a picture of how to do this in Designer.

- FusionTable: share the FusionTable with the ServiceAccount Email address.

Good luck :)

[Yusuf Jk]

Okay, So after doing the pizza party tutorial i think i am on a right track now. but  i get a 400 parse error message i dont know what is wrong in the code. Please help

[Taifun]

Frequent Made Errors with Fusiontables and how to fix them

Taifun

[Yusuf Jk]

I already tried finding solution on your website but i still couldn't find the way to do it.

[Taifun]

you forgot the spaces before and after the table id

see also my red markers in the screenshot

Taifun

[Yusuf Jk]

Finally, now i can access my database. this was possible only because of your help Taifun. Thanks alot :)