I am running a problem with exporting a Google Docs (spreasheet) to xls file and save to our own server.
After successfully uploaded a file to Google Docs but somehow getting the 401 error message when I do the download.
Fatal error: Uncaught exception 'Zend_Gdata_App_HttpException' with message 'Expected response code 200, got 401
<HTML>
<HEAD>
<TITLE>Unauthorized</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000">
<H1>Unauthorized</H1>
<H2>Error 401</H2>
</BODY>
</HTML>
Here is our PHP code and hope someone could help me to point out what went wrong.
Any thoughts would be highly received.
<?php
// set credentials for ClientLogin authentication
$google_user = 'xxxxx'; // Your google account username
$google_pass = 'xxxxx'; // Your google account password
$service = Zend_Gdata_Docs::AUTH_SERVICE_NAME;
$httpClient = Zend_Gdata_ClientLogin::getHttpClient($google_user, $google_pass,$service);
$docs = new Zend_Gdata_Docs($httpClient);
// Uploading file to Google Docs works perfectly as below
//$newDocumentEntry = $docs->uploadFile('test.txt', 'order-123456','text/plain', Zend_Gdata_Docs::DOCUMENTS_LIST_FEED_URI);
$path = "/var/www/vhosts/googledocs";
$docsQuery = new Zend_Gdata_Docs_Query();
$docsQuery->setTitle("My Spreadsheet Name");
$docsQuery->setTitleExact(false);
$feed = $docs->getDocumentListFeed($docsQuery);
foreach ($feed->entries as $entry) {
$docID = $entry->getId();
$docTitle = $entry->getTitle();
if($entry->getTitle() == "My spreadsheet File Name"){
$strURL = $entry->content->getSrc() . '&exportFormat=xls&format=xls';
$data = $docs->get($strURL);
file_put_contents($path."test.xls", $data);
}
}
?>
UPDATE - 23/05/2012
We finally got it working by tweaking the code as below: It would be useful for someone !
foreach($feed as $entry):
if($entry->getTitle() == 'My Spreadsheet File Name'){
$path = "/var/www/vhosts/regustouchstone.com/subdomains/docs/httpdocs/googledocs";
$strURL = "https://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=".basename($entry->id)."&exportFormat=xls&format=xls";
try{
$data = $service->get($strURL)->getBody();
$fp = fopen($path."/test.xls", "w+");
fwrite($fp, $data);
fclose($fp);
}catch(Zend_Exception $e) {
echo "<br /><br /> ERROR <br />";
echo $e->getMessage();
}
}
endforeach;
