1

Hi I have a public google spreadsheet at Google Docs. However when i request the JSON with: 

$.getJSON( "https://spreadsheets.google.com/feeds/list/0Ak0qDiMLT3XddHlNempadUs1djdkQ0tFLWF6ci1rUUE/od6/public/values?alt=json-in-script&callback=?&gid=0", function (data) { console.log(data) })

I get a HTTP 400 request error. Strangely the same exact code works for this spreadsheet.

What's going on here? Thanks a lot.

Improve this question

2 Answers 2

Reset to default
3

I was looking for a solution to the same problem. It led me to this.

Just want to share the fix:

"Warning: API requests using the public visiblity for feeds on spreadsheets that are not "Published to the Web" yield an HTTP 400 Bad Request response with the message The spreadsheet at this URL could not be found. Make sure that you have the right URL and that the owner of the spreadsheet hasn't deleted it."

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

From my experience, I guess you maybe had forgotten to share it or forgotten to make it public. I just tried it and it is working fine. By entering this link in a browser:

https://spreadsheets.google.com/feeds/list/0Ak0qDiMLT3XddHlNempadUs1djdkQ0tFLWF6ci1rUUE/od6/public/values?alt=json-in-script&gid=0

Improve this answer

1 Comment

Yeah that is the json for the spreadsheet I said was working... Not the one that isn't working. My spreadsheet is already public. Thanks though.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.