检索 Google 电子表格工作表 JSON [英] Retrieve Google Spreadsheet Worksheet JSON

问题描述

我尝试接收 Google 电子表格工作表的 JSON.它一直工作到几天前.对于默认工作表，它仍然有效，但不适用于所有其他工作表.

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.

这是默认工作表的工作网址:https://spreadsheets.google.com/feeds/list/1caRqAA1TyBoZ0eVZvvKheEBh9SGRmQII4qih9urY70k/od6/public/full?alt=json

This is the working URL for the default worksheet: https://spreadsheets.google.com/feeds/list/1caRqAA1TyBoZ0eVZvvKheEBh9SGRmQII4qih9urY70k/od6/public/full?alt=json

这是停止工作的工作表的 URL:https:///spreadsheets.google.com/feeds/list/1caRqAA1TyBoZ0eVZvvKheEBh9SGRmQII4qih9urY70k/1416241220/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

错误信息是grid_id 的查询参数值无效.

唯一的区别是工作表参数(od6 vs 1416241220).

Only difference is the worksheet parameter (od6 vs 1416241220).

关于为什么突然发生该错误的任何想法?

Any ideas on why that error suddenly occurs?

推荐答案

ChrisPeterson 的注释:

您可以使用工作表位置编号(第一个/默认工作表为 1，第二个工作表为 2).

You can use worksheet position number (1 for the first/default worksheet, 2 for the second worksheet).

原答案

我遇到了同样的问题，我设法找到了出路.似乎他们最近更改了每个工作表的 ID.

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.

您可以在以下位置找到新 ID

You can find the new ID at the following

https://spreadsheets.google.com/feeds/worksheets/YOUR_SPREADSHEET_ID/private/full

我在 标签之间得到了类似 o3laxt8 的东西

I got something like o3laxt8 between <id> tags

Ps:od6 和default 值将始终有效并重定向到文档的第一个工作表.

Ps: od6 anddefault values will always work and redirect to the first worksheet of your document.

Joe Germuska 的注释:

od6 不再工作

od6 doesn't work anymore

似乎又可以工作了.

这篇关于检索 Google 电子表格工作表 JSON的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！