ddavisqa / google-refine

Automatically exported from code.google.com/p/google-refine
0 stars 0 forks source link

Importing data from Google spreadsheet via visualisation API query #375

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
1. I'm trying to load in a subest of data from a Google spreadsheet using a 
query of the form:
http://spreadsheets.google.com/tq?tqx=out:csv&tq=select%20A%2CB%2CE%20where%20E%
20%3C%209000&key=0AonYZs4MzlZbdHVwQlVnd0ZxQkRmQjQ4NzhFSzJ2VVE

2. Google Refine loads in a whole sheet 

What I would like is just just pull in the data specified by the full URI I 
provided.

What version of Google Refine are you using?
Version 2.0 [r1836]

What operating system and browser are you using?
Mac os/x 10.5.8, Chrome 11.0.*.*

Original issue reported on code.google.com by tony.hi...@gmail.com on 4 May 2011 at 9:23

GoogleCodeExporter commented 8 years ago
I'll take a look.  As a workaround you can hit that URL with a browser, save 
the results, and then load the resulting "data.csv" file.

Original comment by tfmorris on 4 May 2011 at 3:03

GoogleCodeExporter commented 8 years ago

Original comment by tfmorris on 4 May 2011 at 3:05

GoogleCodeExporter commented 8 years ago
This works correctly in David's new v2.5 implementation.

Original comment by tfmorris on 22 Sep 2011 at 11:20