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





All Articles