检索Google电子表格工作表JSON [英] Retrieve Google Spreadsheet Worksheet JSON
问题描述
我尝试收到Google Spreadsheet Worksheet的JSON。它工作到几天前。
这是默认工作表的工作网址： https://spreadsheets.google.com/feeds/list/1caRqAA1TyBoZ0eVZvvKheEBh9SGRmQII4qih9urY70k/od6/public/full?alt=json
这是停止工作的工作表的网址：https://spreadsheets.google.com/feeds/list/1caRqAA1TyBoZ0eVZvvKheEBh9SGRmQII4qih9urY70k/1416241220/public/full?alt=json
错误消息是 grid_id的无效查询参数值。
唯一不同的是工作表参数 od6 vs 1416241220 ）。
那个错误突然发生了？
原始答案
我遇到了同样的问题，我设法找到了出路。
他们似乎最近更改了每个工作表的ID。
您可以在以下位置找到新ID：
https://spreadsheets.google.com/feeds/worksheets/YOUR_SPREADSHEET_ID/private/full
我在< id> 标签之间找到了 o3laxt8
ps： od6 和默认值将始终有效并重定向到文档的第一个工作表。 / p>
Joe Germuska'note：
od6 不再有效
似乎再次运作。
I try to receive the JSON of a Google Spreadsheet Worksheet. It worked till some days ago. For the default worksheet it still works, but not for all other worksheets.
This is the working URL for the default worksheet: https://spreadsheets.google.com/feeds/list/1caRqAA1TyBoZ0eVZvvKheEBh9SGRmQII4qih9urY70k/od6/public/full?alt=json
And this is the URL for the worksheet that stopped working: https://spreadsheets.google.com/feeds/list/1caRqAA1TyBoZ0eVZvvKheEBh9SGRmQII4qih9urY70k/1416241220/public/full?alt=json
The error message is Invalid query parameter value for grid_id.
Only difference is the worksheet parameter (od6 vs 1416241220).
Any ideas on why that error suddenly occurs?
ChrisPeterson's note:
You can use worksheet position number (1 for the first/default worksheet, 2 for the second worksheet).
Original answer
I came across the same issue and I managed to find my way out. It seems that they recently changed the id for each worksheet.
You can find the new ID at the following
https://spreadsheets.google.com/feeds/worksheets/YOUR_SPREADSHEET_ID/private/full
I got something like o3laxt8 between <id> tags
Ps: od6 anddefault values will always work and redirect to the first worksheet of your document.
Joe Germuska' note:
od6 doesn't work anymore
Seems to work again.
这篇关于检索Google电子表格工作表JSON的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
