使用Google Spreadsheet作为使用tabletop转换为数据表的JSON文件会返回错误 [英] Using Google Spreadsheet as JSON file using tabletop to datatables returns error

问题描述

在编码方面，我是一个相对的新手，尤其是javascript。我目前正在尝试从谷歌电子表格中填充一个表格，当电子表格被更新时，它将被更新。

我遵循这个教程每个字（基本上所有你需要做的是用你自己的密钥来替换你的电子表格，并确保它的发布和公开，我已经完成了）

http://dataforradicals.com/the-absurdly-illustrated-guide-to- sortable-searchable-online-data-tables /

我只是收到一个错误的请求400错误，指向我的电子表格。如果我直接访问生成的电子表格，我只会得到单词......

sq的查询参数值无效。

https://spreadsheets.google.com/feeds/list/1UcfO9GHePQrcixZB_R9uVXr1vHVqVTDg7DdsOjpm-K0/od6/public/values?alt=json-in-script&sq=&callback=Tabletop.callbacks .tt140241226993949106

我可以通过我在这里发布的链接访问我的电子表格。

[达到最大链接但结构不同]

正如您所看到的，域结构是不同的。我担心Tabletop to Datatables会在该链接的开始处添加过时的url，但无法找到它实际应用的位置。

我唯一的原因认为这不会发生是因为教程中的示例仍然有效！它引用的链接也是旧式网址。

我很困惑，如果可以的话，请帮忙。所有建议表示赞赏

解决方案

这个项目有一个更新版本。这里包括任何必要的更新：
https://github.com/scottpham/tabletop to-datatables

尝试使用所有js库的更新版本。

检查链接并删除pub后的额外字符串。这部分链接并不是必要的，可能会导致问题。

根据google：

400错误请求错误是一个HTTP状态代码，这意味着您发送给网站服务器的请求通常很简单，就像加载网页的请求一样，但某种方式不正确或损坏，服务器无法理解。

祝你好运

I'm a relative newbie when it comes to coding, especially javascript. I currently am trying to populate a table from a google spreadsheet, which will update when the spreadsheet is.

I followed this tutorial word for word (basically all you need to do is replace the key with your own to specify your spreadsheet, and make sure its both published and public, which I've done)

http://dataforradicals.com/the-absurdly-illustrated-guide-to-sortable-searchable-online-data-tables/

I just get a bad request 400 error referring to my spreadsheet. If I visit the spreadsheet generated directly I just get the words...

"Invalid query parameter value for sq."

https://spreadsheets.google.com/feeds/list/1UcfO9GHePQrcixZB_R9uVXr1vHVqVTDg7DdsOjpm-K0/od6/public/values?alt=json-in-script&sq=&callback=Tabletop.callbacks.tt140241226993949106

I can visit my spreadsheet with the link I was given when I published it here..

[maximum links reached but the structure is different]

As you can see the domain structure is different. I fear that "Tabletop to Datatables" is adding an outdated url to the start of that link but can't find where it actually applies it.

The only reason I would think thats not happening is because the example in the tutorial still works! And the link it refers to is the old style URL too

I'm baffled, please help if you can. All suggestions appreciated

解决方案

There is an updated version of this project. Any necessary updates are included here: https://github.com/scottpham/tabletop-to-datatables

Try with the updated versions of all js libraries.

Check the link and remove the extra string after pub. That part of link is not necessary and may cause issues.

According to google:

The 400 Bad Request error is an HTTP status code that means that the request you sent to the website server, often something simple like a request to load a web page, was somehow incorrect or corrupted and the server couldn't understand it.

Good luck

这篇关于使用Google Spreadsheet作为使用tabletop转换为数据表的JSON文件会返回错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！