403 error when making an SQL query for a Fusion Table

Question

I've been trying to migrate my project to new API, but I get the following error when trying out an SQL query such as the following:

https://www.googleapis.com/fusiontables/v1/query?sql=SELECT * FROM 1KxVV0wQXhxhMScSDuqr-0Ebf0YEt4m4xzVplKd4&key=myKey

Here is what gets returned:

{
 "error": {
  "errors": [
   {
    "domain": "usageLimits",
    "reason": "accessNotConfigured",
    "message": "Access Not Configured"
   }
  ],
  "code": 403,
  "message": "Access Not Configured"
 }
}

The following query does work, though: https://www.googleapis.com/fusiontables/v1/tables/1bTX-w0Lt6nT8jq4R0q2pwFvuN_X5iPDOKHWFhw/columns?key=myKey

What am I doing wrong?

For me, both queries work when I enter my API key. Did you already fix the issue? — Odi, Jul 25 '12 at 15:33

score 6 · Accepted Answer · answered Nov 05 '12 at 13:56

6

You also need to make sure the Fusion Table is Exportable.

File → About this table
       → Edit table information
         → Check the "Allow download" checkbox

answered Nov 05 '12 at 13:56

Labu

2,572
30
34

score 2 · Answer 2 · answered Jul 30 '12 at 08:52

2

I started a new project in the API console and using the new API key fixed it, strangely.

answered Jul 30 '12 at 08:52

Maarten

6,894
7
55
90

403 error when making an SQL query for a Fusion Table

2 Answers2

Linked