Download
Browse source Changelog
Documentation
Project   Bug Bounty   Help us   Known bugs   TODO Protocols   CA bundle   HTTP Cookies   HTTP/2   SSL Certs Releases   Security   Version numbers   Vulnerabilities curl tool   man page   Tutorial   HTTP scripting Who and Why
libcurl
ABI API Competitors Examples Features Mailing list Related libs Using libcurl Tutorial Testimonials
Get Help
curl-library curl-users Mailing lists Book: Everything curl Video presentations Report a bug Paid support
Development
Autobuilds Code Style Contribute Deprecate Internals Release Notes Release Procedure Roadmap Run Tests Security Process Specifications Test curl
News
Changelog Release table
curl / Mailing Lists / curl-users / Single Mail
Buy commercial curl support from WolfSSL. We help you work out your issues, debug your libcurl applications, use the API, port to new platforms, add new features and more. With a team lead by the curl founder himself.

Re: Problem with published google sheet

From: Ray Satiro via curl-users <curl-users_at_cool.haxx.se>
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:
>
> https://docs.google.com/spreadsheets/d/e/2PACX-1vSH5R8xG1ARb4Swjjl8qYbzRZdBsEcTOFGrEkToW1ln3akG3Gchzfd9r6od6EPGRldu_jcx7YMu7lCq/pub?gid=606625683&single=true&output=tsv
>
> 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:
>
> https://docs.google.com/spreadsheets/d/e/2PACX-1vT-9DWdR54wvnrD6FLXKXKXQBOZ8pLU2PpcYt-uaPfoicwBjUVpzs7kNLIc_R9WFoTQd2cA8VxdkCP8/pub?gid=0&single=true&output=tsv
>
> Even in this case, I need to modify the url as follows to download the
> file:
>
> curl
> https://docs.google.com/spreadsheets/d/e/2PACX-1vT-9DWdR54wvnrD6FLXKXKXQBOZ8pLU2PpcYt-uaPfoicwBjUVpzs7kNLIc_R9WFoTQd2cA8VxdkCP8/pub?output=tsv
>
> 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

-----------------------------------------------------------
Unsubscribe: https://cool.haxx.se/list/listinfo/curl-users
Etiquette: https://curl.haxx.se/mail/etiquette.html
Received on 2019-09-16