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.
