Hello,

I'm trying to write a string query that returns a few different things-- 
but I would like to filter which campaigns are returned by campaign ID. 
Here's the string query I have wrote so far:

String query = 
"SELECT campaign.id, campaign.name, 
campaign.vanity_pharma.vanity_pharma_text FROM campaign 
WHERE campaign.id 11031113693 
ORDER BY campaign.id";

The error says:

Response
--------
Headers: 
Metadata(content-type=application/grpc,request-id=wQ_YJlu7-Ph0bn9VuLHJNg,date=Mon,
 
12 Jul 2021 19:30:17 GMT,alt-svc=h3=":443"; ma=2592000,h3-29=":443"; 
ma=2592000,h3-T051=":443"; ma=2592000,h3-Q050=":443"; 
ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; 
ma=2592000,quic=":443"; ma=2592000; v="46,43")
Body: null
Failure message: errors {
  error_code {
    query_error: UNEXPECTED_INPUT
  }
  message: "Error in query: unexpected input 11031113693."
}


It worked before I entered the "WHERE" part of the query, but now it 
doesn't seem to be working. Any help you could provide on how to write this 
query would be really appreciated.

Thanks!

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/be11fb59-8d8d-4fd2-a3ec-71f00985f7a7n%40googlegroups.com.
  • GAQL String Quer... 'reid hommedahl' via AdWords API and Google Ads API Forum

Reply via email to