Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Faster querying through JSON feed? #11

Open
7imon7ays opened this issue Jan 22, 2015 · 0 comments
Open

Faster querying through JSON feed? #11

7imon7ays opened this issue Jan 22, 2015 · 0 comments

Comments

@7imon7ays
Copy link
Owner

https://spreadsheets.google.com/feeds/list/SHEET_ID/od6/public/full?alt=json returns a JSON string of a spreadsheet if the sheet is published. Relevant paths seems to be

root["feed"]["entry"][i]["title"]

and

root["feed"]["entry"][i]["content"]

Where i is the record's row index. The title key points to the value in row i, column A, content maps the names of the columns to the right of A with the corresponding cells in row i, under the format

"column_i_name: cell_i_value, column_i+1_name: cell_i+1_value"

Probably faster for read operations. Doesn't allow write operations.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant