2017년 4월 2일 일요일

Access (Read & Write) to/from Fusion Tables from App Inventor 2 App


Any good tutorial about how to get the API KEY ?  As well as the relationship between API KEY and TABLE ID for Fusion Tables. ALL the tutorials and Videos I have seen are really old ones including the one from MIT (Pizza Party with Fusion Tables for App Inventor 2). Im getting the error : 401 Unauthorized invalid credentials while trying the Pizza Party example. I didnt find any valuable information troubleshooting this issue. Thanks.

--
It does not look like you have used the forums yet, as a search using the search box above would have returned several threads about this topic.

Advice: Before posting, it's a good idea to search in this forum. Many others have likely run into problems similar to yours. How to search see screenshot.
Hi Taifun, thanks for your prompt response.
In fact I was searching the forums, google help pages, and others more than 5 hours and didnt find something useful.
But seems like the tutorials are really old , google web pages like the console looks different, many menus and option are not available at this moment.

Today I was following the tutorial, as per your recommendation : https://puravidaapps.com/fusionservice.php

But when I try to fill the ServiceAccountEmail at the app inventor block area, apparently this data was not defined in step 8 like the tutorial mentioned.
I dont know if this tutorial is working right now, or if somebody has been working with it recently.

Im including a document with the process I follow,  please take a look and let me know your comments.
Thanks a lot.


--
use the email you got from the setup
Google changes the user interface frequently, my page was updated on Nov 22nd and now it's again different...

and if you are up and running, you are invited to prepare screenshots of the complete setup steps and provide them for the community. thank you.

see also tip 2 here
after reading your comment in this thread

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
 

it seems to be, you still have issues?
You might want to provide some more details?

Concerning the service account method, just follow these 3 steps

1. Developers Console: create a Service Account. After creating a service account in the developer console you get a p12 file to download and a service account email to use in App Inventor.
2. FusionTable: share the FusionTable with the ServiceAccount Email address and set the permissions to "can edit".
3. App Inventor: The p12 file must be uploaded as asset into App Inventor and this is the file referenced to in the Keyfile property

--
Everything seems to be working fine now, finally I was able to read the Fusion table

--

댓글 없음:

댓글 쓰기