0

I have a published Google Doc at https://docs.google.com/spreadsheet/pub?key=0AtjON-ccqVTgdDhKeGx0UlZpUWUyLTFZV2szQlJyNnc&output=html that I want to retrieve in JSON. I've been trying this but it’s not working:

https://developers.google.com/gdata/samples/spreadsheet_sample

  • How does it 'not work'? Any error message? – Vidar S. Ramdal Jan 14 '13 at 9:23
  • it just says invalid, i'm still trying it – Noor Jan 14 '13 at 9:25
  • It would be nice to have a full working example from Google (I'm a newbie with JSON, jQuery, Javascript, etc). – Oneide Jan 15 '13 at 17:55
1
https://spreadsheets.google.com/feeds/list/[[your key here]]/od6/public/values?alt=json

Source: http://blog.pamelafox.org/2013/06/exporting-google-spreadsheet-as-json.html

The author doesn't explain it super well, but if you just swap out your key for hers in the example provided in the comments, that works.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.