Expected response code 200, got 404
After months of successful operation my google spreadsheets implementation (using cakePHP and Zend Framework just stopped working. After reading this post on google groups it became obvious that the urls used for the API have changed slightly, the arrays returned in various responses have also been reordered.
If you’re getting this error all of a sudden, firstly change line 93 (approx) of the file Zend/Gdata/Spreadsheets.php file from:
const SPREADSHEETS_FEED_URI = ‘http://spreadsheets.google.com/feeds/spreadsheets’;
to:
const SPREADSHEETS_FEED_URI = ‘http://spreadsheets.google.com/feeds/spreadsheets/private/full’;
Any references therafter you should check your responses, any urls for example you generate using a split() on the url (to get worksheet id’s) etc will need to be updated.
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.

Comments
No comments yet.
Leave a comment