Special characters in the WHERE clause in the AdWords API

[Noémi Molnár]

Hi,

The QueryError.INVALID_WHERE_CLAUSE is returned when there are special characters, like '#', '-', '.' in the WHERE clause of the call to the AdWords API, even is we encode or escape these characters. Is it the excepted behaviour of the API, is there any way to use these characters in the WHERE clause?

Kind regards,

Noemi Molnar

[googleadsapi...@google.com]

Hello Noemi,

The special characters are not allowed in where clause. This is an expected behavior. For more information, please refer to this guide. If you are still facing an issue, please share the query so that I can assist you further. You can use 'Reply privately to author' option while responding. 

Thanks,
Milind, AdWords API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/