AQWL to GAQL: Confused about changes in withCondition clauses

[aya abeliovich]

Hey there,

I'm trying to update the scripts in our account with the new GAQL syntax.

I've never really explicitly used AWQL, I only use it when calling withCondition so I'm a little clueless.

I have several calls to 

.withCondition(campaign.name IN ["List", "Of", "Possible", "Campaigns"]);

When I try to preview my script I get this exception message:

Exception: Call to GoogleAdsService.Search failed: Error in WHERE clause: invalid value [

This type of call used to work in the old syntax. Does it not work anymore? If so, what should I replace it with to expect the same result?

Thanks,

Aya.

[Sigurd Fabrin]

Try this tool to build GAQL queries https://developers.google.com/google-ads/api/fields/v9/ad_group_query_builder

For the IN operator, use regular parentheses instead of brackets

Cheers

 Sigurd

[Google Ads Scripts Forum Advisor]

Hello Aya,

 

Thank you for reaching out to us. I’m James from the Google Scripts support team. Allow me to assist you.

 

I agree with Sigurd. With the use of the IN operator, you must use parentheses instead of using brackets. For much easier construction of query, you may try this Google Ads query builder tool.

 

Let me know if you have any questions.

 

Regards,

James Howell Abarsoza Google Ads Scripts Team

ref:_00D1U1174p._5004Q2W5G9d:ref