Problems getting data from Google Spreadsheet with Zend Gdata - Empty result
I am trying to connect to google spreadsheet using zend GData library as shown below.
// Google user account
$username = GOOGLE_USERNAME; // Your google account username
$password = GOOGLE_PASSWORD; // Your google account password
// Document key - get it from browser addres bar query key for your open spreadsheet
$key = GOOGLE_SPREADSHEET_KEY;
// Init Zend Gdata service
$service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
$client = Zend_Gdata_ClientLogin::getHttpClient($username, $password, $service);
$spreadSheetService = new Zend_Gdata_Spreadsheets($client);
// Fetch recorded response data from Google Spreadsheet
try {
// get spreadsheet entry
$ssEntry = $spreadSheetService->getSpreadsheetEntry('https://spreadsheets.google.com/feeds/spreadsheets/' . $key);
// get worksheets in this spreadsheet
$wsFeed = $ssEntry->getWorksheets();
} catch (Exception $e) {
die('ERROR: ' . $e->getMessage());
}
I am getting below error:
ERROR: DOMDocument cannot parse XML: DOMDocument::loadXML(): Empty string supplied as input
The problem is that google removed ClientLogin tool from google API Now I need to use zend GData library with OAuth or OAuth2
Please help me with this part, I am in no hurry.
Or does anyone know any other PHP solution to solve the problem. He will be very grateful.
Thanks in advance.
+3
source to share
No one has answered this question yet
Check out similar questions: