Re: Problem with published google sheet
Date: Mon, 16 Sep 2019 14:18:48 -0400
On 9/16/2019 4:14 AM, Boyd Kelly via curl-users wrote:
> I have not been able to download a publicly published google sheet in
> tsv with curl.?? (There is no authorization here)?? The problem seems to
> stem from the gid that identifies the particular tab/sheet that is
> published.?? Here is a sample url:
> If I simply click on this link in a browser I am prompted with a
> filename to save this as tsv and it works.?? With curl I just get a
> bunch of script that downloads.?? I've tried various options (-O -J -L etc)
> One thing I notice is that if there is only *ONE* sheet in the
> workbook that is published and then I remove the gid=number and
> single=true parts of the url I can download the file.
> This is the same sheet as above but 'published' from a workbook where
> there it is the only sheet:
> Even in this case, I need to modify the url as follows to download the
> However I need to download two sheets, so this is not ideal for me.??
> Any ideas as to why this is happening??? It does appear to be some
> issue where the gid selects the sheet to download.?? But why does it
> work fine in a browser but not with curl??? Is this a pure Google
> problem??? Or is there some curl magic that can deal with this?
Quote the URL otherwise the ampersand & is interpreted as a shell character