Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

share|improve this question
    
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
add comment

1 Answer

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.

share|improve this answer
    
You need to add the script though.... –  Jacob Jan Tuinstra Oct 1 '13 at 11:16
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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