NUKnightLab / TimelineJS3

TimelineJS v3: A Storytelling Timeline built in JavaScript. http://timeline.knightlab.com
Mozilla Public License 2.0
3k stars 621 forks source link

sheets-proxy 400 error #825

Closed borayeris closed 1 year ago

borayeris commented 1 year ago

https://sheets-proxy.knightlab.com/proxy/https://docs.google.com/spreadsheets/d/15lBZRjtqVL_HYeXDZS4CfqaU79n-_MStNuiGhR9jSqs/pub?output=csv

{"content":"<meta name=viewport content=\"initial-scale=1, minimum-scale=1, width=device-width\">Error 400 (Bad Request)!!1<style nonce=\"Pmh8UbUeZfQKhOTBwSaU0A\">{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{color:#222;text-align:unset;margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px;} > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}pre{white-space:pre-wrap;}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}<main id=\"af-error-container\" role=\"main\">

400. That\u2019s an error.

The server cannot process the request because it is malformed. It should not be retried. That\u2019s all we know.","message":["Error [400] fetching sheets data. Did you publish your sheets document to the web?"],"proxy_err_code":"response_not_ok"}

JoeGermuska commented 1 year ago

TimelineJS cannot read your spreadsheet. When I visit https://docs.google.com/spreadsheets/d/15lBZRjtqVL_HYeXDZS4CfqaU79n-_MStNuiGhR9jSqs/pubhtml I get this message:

image

This is usually an indication that you created your Google Sheets document in a private Google Workspace which doesn't truly permit "publish to the web." This is a setting left to the discretion of your local workspace administrator. You may have published it so that anyone in your organization can view the document, but that doesn't allow TimelineJS to read the contents.

You must either consult your local administrator to get them to enable true "publish to the web" or you must copy your spreadsheet into a public sheets.google.com spreadsheet, which doesn't have that restriction.