odino / docsql Goto Github PK

This tool has been extremely helpful for my job, thank you very much for sharing this publicly. Unfortunately, I started been having an issue with it. Even though I use the correct link to download the table with this URL format:
https://docs.google.com/spreadsheets/d/<TABLE_ID>/export?format=tsv&gid=<SHEET_GID>
I get the message
Unrecoverable error: The file we downloaded has content type '[text/html; charset=UTF-8]', while we expected 'text/tab-separated-values'. Are you sure you entered the right URL?

This URL format works for most of the tables but not for some.

When I comment out the part which checks for the table format (tsv) I get this parsing error which might be helpful figuring out the problem we're facing.

Unrecoverable error: parse error on line 3, column 11: bare " in non-quoted-field

I checked the table and it doesn't have any character (like ", \t, ',') that might have caused the parsing error.

Do you have any idea why I might be facing this problem?
I think it might be happening from a redirected link. If a download link is redirected, the downloaded file with curl will include the html file which will include the redirected link. Is there a way to follow redirections and download the very last file that is reached?

Hi there, first of all - thank you so much for developing this software, it was exactly what I was looking for, and works like a charm.

I can't seem to get the archived tables to be deleted. I've experimented with different settings for -k (--keep) but none are deleted, even though command-line output seems to claim it is doing so:

2019/03/20 16:06:05 Connecting to MySQL... 2019/03/20 16:06:05 Clearing old tables... 2019/03/20 16:06:05 All done

The user has DROP privileges.

MIT, GNU, etc..?

Keep getting the error Unrecoverable error: The file we downloaded has content type '[text/html; charset=UTF-8]', while we expected 'text/tab-separated-values'. Are you sure you entered the right URL?

This was working fine last week. Doc URL ends with /export?format=tsv