Yes, pure brute force trial and error :-)
On 2 Jan., 01:28, Erwin Quinto <erwin.qui...@gmail.com> wrote:
> So we have to enclose it with double quotes. Thanks for the info
> systemaddict! How were you able to find that out? Is it just pure
> guess or what?
>
> On Dec 31 2009, 5:07 pm, systemaddict <sysadd...@gmail.com> wrote:
>
>
>
> > It seems that this is working:
>
> > query.setSpreadsheetQuery("email = \"whate...@domain.com\"");
>
> > On 30 Dec., 22:50, Brian <bpmurp...@gmail.com> wrote:
>
> > > Something has definitely changed within the past few days in the
> > > processing of structured queries through the Google Spreadsheets Data
> > > API. I am also encountering the "invalid token" exception on queries
> > > that have worked for months. In my case the offending character is
> > > "#". As I have always done, the text is enclosed in quotes. When
> > > encountering this error yesterday (and again today), I tried both URL
> > > and HTML encoding to see if that would resolve this new error.
> > > Neither was successful. I am looking for guidance as to the nature of
> > > the change in structured query processing and how we are supposed to
> > > now handle non-alpha characters in queries.
>
> > > On Dec 29, 8:43 am, Erwin Quinto <erwin.qui...@gmail.com> wrote:
>
> > > > Hi I'm using Google Spreadsheets Data API for my current project. We
> > > > stored employee records on the a google spreadsheet. We have a
> > > > requirement toqueryall records with the given email address. Here's
> > > > my sample code:
>
> > > > RecordQueryquery= new RecordQuery(recordsFeedUrl);
> > > > query.setSpreadsheetQuery("email=some...@there.org");
> > > > System.out.println(query.getUrl().toString());
> > > > RecordFeed feed = service.query(query, RecordFeed.class);
>
> > > > When I try to run it an "Parse error: Invalidtokenencountered" error
> > > > is thrown. Doing some experiments I found out that the "@" character
> > > > is the one causing the trouble. Would anyone here know how to go about
> > > > this? Did anybody already encountered similar problem?
--
You received this message because you are subscribed to the Google Groups
"Google Docs Data APIs" group.
To post to this group, send email to google-docs-data-a...@googlegroups.com.
To unsubscribe from this group, send email to
google-docs-data-apis+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en.
