I am trying to migrate my project to a new API, but when I try to execute an SQL query, I get the following error:
https://www.googleapis.com/fusiontables/v1/query?sql=SELECT * FROM 1KxVV0wQXhxhMScSDuqr-0Ebf0YEt4m4xzVplKd4 & key = MYKEY
Here is what returns:
{ "error": { "errors": [ { "domain": "usageLimits", "reason": "accessNotConfigured", "message": "Access Not Configured" } ], "code": 403, "message": "Access Not Configured" } }
The following query really works: https://www.googleapis.com/fusiontables/v1/tables/1bTX-w0Lt6nT8jq4R0q2pwFvuN_X5iPDOKHWFhw/columns?key=myKey
What am I doing wrong?
You also need to make sure that the Fusion table is exportable.
File → About this table → Edit table information → Check the "Allow download" checkbox
I started a new project in the API console, and, using a strange interface, fixed its new API key.