Hello,
I'm getting an exception getListFeed($query) line is executed in this
function:
public function getStudentRow() {
$query = new Zend_Gdata_Spreadsheets_ListQuery();
$query->setSpreadsheetKey($this->currKey);
$query->setWorksheetId($this->currWkshtId);
$query->setParam('xoauth_requestor_id', $this->data['teacher_email']);
$query->spreadsheetQuery = 'googlestudentid=\"'.$this->data['user'].'\"';
*$listFeed = $this->gdClient->getListFeed($query);*
if (count($listFeed->entries)==0) { // If student row does not exist -
create it
$this->createNewRowFromData();
$listFeed = $this->gdClient->getListFeed($query);
}
return $listFeed->entries[0];
}
I've found that whenever googlestudentid is set to a string that starts with
a letter, the function call executes fine. However, when the googlestudentid
string starts with a number (such as 95hy) the call fails and I get the
following exception:
Expected response code 200, got 400 Parse error: Invalid token encountered
The var dump looks like the is the URL that's failing:
https://spreadsheets.google.com/feeds/list/tqBL7meh27WUGyg-aZkVoQQ/ocu/private/full?xoauth_requestor_id=xxxx%40xxxx.com&sq=googlestudentid%3D%5C%2295hy%5C%22
Now, the same call with a different googlestudentid works:
https://spreadsheets.google.com/feeds/list/tqBL7meh27WUGyg-aZkVoQQ/ocu/private/full?xoauth_requestor_id=xxxx%40xxxx.com&sq=googlestudentid%3D%5C%22h3hy%5C%22
Does anyone have any ideas?
Thanks!