I found another, better way to do this (refer to my code above):
// ... etc. ...
$query = new Zend_Gdata_Spreadsheets_DocumentQuery();
$query->setDocumentType('spreadsheets');
try {
$feed = $ssService->getSpreadsheetFeed($query);
}
catch (Exception $e) {
echo "<pre>\n";
print_r($e);
echo "</pre>\n";
exit(0);
}
// ... etc. ...
In other words, we create a Zend_Gdata_Spreadsheets_DocumentQuery
object and we set its document type to 'spreadsheets'. Then, we pass
this query object as an argument to the getSpreadsheetFeed method.
This causes it to automatically modify the URI that it uses internally
into the same form that I explicitly coded in my previous message.
So it appears that the Zend Gdata API indeed has a way to manage the
setting of this URI without the programmer having to explicitly set
it, and without having to hack the underlying code.
Note that we have to be careful not to reuse this query object "as is"
if we're subsequently calling getSpreadsheetKey, because the document
type cannot be set to 'spreadsheets' when that method is being called.
If we reuse that object, we have to do this before calling
getSpreadsheetsKey ...
$query->setDocumentType('');
This begs a new question: is any of this documented? I couldn't find
any docs which describe how to use the methods of the
Zend_Gdata_Spreadsheets_DocumentQuery in order to solve this kind of
problem, and I had to figure it out by looking through the source code
for the Zend/Gdata package. This apparent lack of docs caused me to
waste quite a few hours, and I would guess that this loss of person-
hours has been multiplied many times over by others who have to solve
the same problems.
It's good that we have these forums where we can share our knowledge,
but I believe that its incumbent upon the developers/releasers of Zend/
Gdata to provide more detailed documentation about the structure of
the objects they release and their use in these common tasks. Sample
code is provided and it's helpful, but it isn't enough without proper
documentation.
... or have I simply missed a discussion of this somewhere in the
official docs?
On Oct 18, 12:49 am, HippoMan <[EMAIL PROTECTED]> wrote:
> Well, I found a solution:
>
> http://groups.google.com/group/Google-Docs-Data-APIs/browse_thread/th...
>
> I have to pass the following argument to getSpreadsheetFeed():
>
> 'http://spreadsheets.google.com/feeds/spreadsheets/private/full'
>
> In other words ...
>
> $feed = $ssService->getSpreadsheetFeed('http://spreadsheets.google.com/
> feeds/spreadsheets/private/full');
>
> This is necessary because the default URI used within the
> Zend_Gdata_Spreadsheets class isn't correct ... at least not for the
> way I'm using it here. The default is 'http://spreadsheets.google.com/
> feeds/spreadsheets'.
>
> Does that default work for certain kinds of spreadsheets, or is it no
> longer valid at all? If it's the latter, then the ZendGdata code needs
> to be changed.
>
> It turns out that the gdata.py API uses a URI of the form
> http://{X}/feeds/spreadsheets/{Y}/{Z} where {X} defaults to
> 'spreadsheets.google.com', {Y} defaults to 'private', and {Z} defaults
> to 'full', and where {X}, {Y}, and {Z} are overridable at run time.
> Methinks that the ZendGdata API should use the same defaults.
>
> On Oct 17, 10:39 pm, HippoMan <[EMAIL PROTECTED]> wrote:
>
> > I'm trying to use the Zend Gdata API to retrieve data from some Google
> > spreadsheets, and I'm following the pattern described in this
> > document:http://framework.zend.com/manual/en/zend.gdata.spreadsheets.html.
> > However, when I issue the getSpreadsheetFeed() method as described in
> > that document, my application throws an exception.
>
> > Here's my code (email and password changed to dummy values):
>
> > $email = '[EMAIL PROTECTED]';
> > $pw = 'my-password';
> > $service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
> > try {
> > $client = Zend_Gdata_ClientLogin::getHttpClient($email, $pw,
> > $service);}
>
> > catch (Zend_Gdata_App_CaptchaRequiredException $cre) {
> > echo 'URL of CAPTCHA image: ' . $cre->getCaptchaUrl() . "<br/>\n";
> > echo 'Token ID: ' . $cre->getCaptchaToken() . "<br/>\n";
> > exit(0);}
>
> > catch (Zend_Gdata_App_AuthException $ae) {
> > echo 'Problem authenticating: ' . $ae->exception() . "<br/>\n";
> > exit(0);}
>
> > echo "Authenticated<br/>\n";
> > $ssService = new Zend_Gdata_Spreadsheets($client);
> > echo "ssService created<br/>\n";
> > $feed = $ssService->getSpreadsheetFeed();
> > echo "feed created<br/>\n"
> > foreach ($feed->entries as $entry) {
> > echo $entry->title->text .' '. $entry->content->text . "<br/>\n";
>
> > }
>
> > The exception gets thrown right at the getSpreadsheetFeed() method
> > call. Here are the first few lines:
>
> > An error occurred
> > Application error
> > Exception information:
>
> > Message: Expected response code 200, got 404
> > Not Found
> > Error 404
>
> > Stack trace:
>
> > #0 /home/ofrecord/sites/hotelp/library/Zend/Gdata.php(201):
> > Zend_Gdata_App->performHttpRequest('GET', 'http://spreadsh...', Array,
> > NULL, NULL, NULL)
> > #1 /home/ofrecord/sites/hotelp/library/Zend/Gdata/App.php(610):
> > Zend_Gdata->performHttpRequest('GET', 'http://spreadsh...')
> > #2 /home/ofrecord/sites/hotelp/library/Zend/Gdata/App.php(541):
> > Zend_Gdata_App->get('http://spreadsh...')
> > #3 /home/ofrecord/sites/hotelp/library/Zend/Gdata/App.php(147):
> > Zend_Gdata_App->importUrl('http://spreadsh...', 'Zend_Gdata_Spre...')
> > #4 /home/ofrecord/sites/hotelp/library/Zend/Gdata.php(148):
> > Zend_Gdata_App->getFeed('http://spreadsh...', 'Zend_Gdata_Spre...')
> > #5 /home/ofrecord/sites/hotelp/library/Zend/Gdata/
> > Spreadsheets.php(139): Zend_Gdata->getFeed('http://spreadsh...',
> > 'Zend_Gdata_Spre...')
> > #6 /home/ofrecord/sites/hotelp/application/views/scripts/index/
> > index.phtml(27): Zend_Gdata_Spreadsheets->getSpreadsheetFeed()
> > ... etc. ...
>
> > The email address and password are correct. Furthermore, making the
> > corresponding calls through the gdata.py API works without a problem.
>
> > Can anyone tell me what I'm doing wrong when using this Zend API?
>
> > Thanks in advance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Docs Data APIs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---
