将Google电子表格作为JSON时出错

时间:2020-12-23 09:47:32

I am trying to get a googlespreadsheet data as json using

我正在尝试使用json获取googlespreadsheet数据

https://spreadsheets.google.com/feeds/list/1KI1hps-RpAJZV8AkB6MpxO8V_le--111111111/od6/public/values?alt=json

but I get error message saying: "We're sorry. This document is not published."

但我收到错误消息:“我们很抱歉。此文档未发布。”

The link to spreadsheet itself is working fine and anyone can access (indicating the sharing has no problem)

电子表格本身的链接工作正常,任何人都可以访问(表明共享没有问题)

https://docs.google.com/spreadsheets/d/111111-RpAJZV8AkB6MpxO8V_le--111111/edit#gid=0

Appreciate if anyone can tell me what is the issue here

感谢是否有人可以告诉我这里的问题

1 个解决方案

#1


1  

Those two api endpoints aren't the same. A published spreadsheet isn't the same as one that can be edited by anyone.

这两个api端点不一样。已发布的电子表格与任何人都可以编辑的电子表格不同。

Not sure why it needs to be published to export it as json, but here are the instructions:

不知道为什么需要发布它以将其导出为json,但以下是说明:

https://support.google.com/docs/answer/37579?hl=en

#1


1  

Those two api endpoints aren't the same. A published spreadsheet isn't the same as one that can be edited by anyone.

这两个api端点不一样。已发布的电子表格与任何人都可以编辑的电子表格不同。

Not sure why it needs to be published to export it as json, but here are the instructions:

不知道为什么需要发布它以将其导出为json,但以下是说明:

https://support.google.com/docs/answer/37579?hl=en