I'm trying to import some data from a SHP to GFT (Google Fusion Table).
I get a 401 error. I'm using an Ubuntu 14.04 LTS Linux 64 bits with GDAL 1.11.0, released 2014/04/16. GFT is available (tested with
ogrinfo --formats |grep GFT)
The steps at the moment are :
- Go to https://console.developers.google.com/project
- Create a project
- Activate Google Fusion as one of the available API
- Create credentials with OAUTH for Installed applications with Other to get a client ID and a client secret
Export variables in system with
export GOA2_CLIENT_ID=client ID> export GOA2_CLIENT_SECRET=<client secret>
Both override GDAL_CLIENT_ID and GDAL_CLIENT_SECRET default parameters
python /usr/bin/gdal_auth.pyto open a browser to accept connexion where you get an authorization token (from the browser after connexion). In the console, you will get this message below
Please login and authorize access in web browser... Enter authorization token:
and will need to paste the token. It will generate a refresh token with message in the console like below:
Consider setting a configuration option like: GFT_REFRESH_TOKEN=<refresh token>
export GFT_REFRESH_TOKEN=<refresh token>
ogr2ogr -f GFT "GFT:access=<authorization token>" ~/countries.shp
Get an error like followed
ERROR 1: HTTP error code : 401 ERROR 1: HTML error page returned by server GFT driver failed to create GFT:access=<authorization token>
I also tried with
GFT_REFRESH_TOKEN=<refresh token> ogr2ogr -f GFT "GFT:access=<authorization token>" ~/countries.shp but go the same error
According to some researches, 401 errors in GFT are related to authorisation or scope but I should miss the point here.
So, any clue is welcome!