Questions about the Google Ads Query Language v6

[FW API]

Hello,

I have some question about the language specification.

1. Is there a maximum length to queries?

2. Are there limits on certain clauses within queries? For example the old Adword API produced TOO_MANY_PREDICATES errors. Are those still a think? If so, what are the limits?

3. How exactly does the LIKE operator work?

Thank you.

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for your questions.

Allow me to reach out to the rest of our team and we'll reach back to you with information that can be helpful.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2CRwMV:ref

[Google Ads API Forum Advisor Prod]

Hello - 

Thanks for your questions! I'll answer them inline:

1. We do not specify a maximum length for queries, however they are limited by the maximum message length configured for gRPC. I believe that in our client libraries this limit is set to approximately 64MB.
2. There are no limits to predicates in GAQL queries.
3. The LIKE operator behaves almost identically to the SQL version, the main difference is it's case-insensitive. 

Hope this helps!

Best,
Ben Karl, Google Ads API Team

ref:_00D1U1174p._5004Q2CRwMV:ref

[FW API]

The answer to question is apparently wrong. In case of more than 20k predicate values the API produces FILTER_HAS_TOO_MANY_VALUES.

https://developers.google.com/google-ads/api/docs/best-practices/quotas#other_types_of_limits

[Google Ads API Forum Advisor]

Hello - 

Indeed it looks like I was mistaken, thanks for clarifying this and linking to our documentation!

Best,
Ben, Google Ads API Team

ref:_00D1U1174p._5004Q2CRwMV:ref