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.
