I’ve been playing around with Google Spreadsheets and was attempting to query for an email address stored within a column. It’s pretty straight forward, or at least so I thought, but kept running into the error:
Parse error: Invalid token encountered And stumbled around for awhile trying to URL encode various parts of the query string which looks something like this:
http://spreadsheets.google.com/feeds/list/myDoc/mySheet/private/full?sq={email}%3djohn@doe.com
The documentation states query operators need to be encoded so I tried applying that to parts of my query with no luck. Eventually, I threw some quotes around the email address and voila, it worked!
http://spreadsheets.google.com/feeds/list/myDoc/mySheet/private/full?sq={email}%3d"john@doe.com"
I eventually found this thread validating my findings and indicating my original query might have worked as recently as last December.