INVALID_PREDICATE_OPERATOR CONTAINS_ANY

[sébastien pénagos]

Hi, I'm currently trying to get AdgroupAd where the Url parameters contains a certain string.

Since I have to check for millions of string I decide to use the CONTAINS_ANY Predicate whithin my Get().

Then I'm getting an INVALID_PREDICATE_OPERATOR error .

So I'm wondering  if that the Predicate CONTAINS_ANY is only available for Labels or something like that?

Thank you for your time.

[WZ]

HI 

Not an expert, but ensure that the return of the URL is a stringset. You can use the Conatins_any only on Stringset columns.

[Ray Tsang (AdWords API Team)]

Sebastien,

Could I trouble you to send me the full request/response XML log in private?

Thanks,

Ray

[Ray Tsang (AdWords API Team)]

Also, please try to use "IN" operator as well.

Thanks,

[sébastien pénagos]

Hi, thank you for your answers.

I've test the CONTAINS_ANY Predicate on Labels LABELS with Campaign as the example in the client librairies.

I check with different type of value:

- with integers as 12345

- with double quoted integers (as "12345") , for this two it worked perfectly.

If I try a string as "test", I get an error (UNEXPEXTED_INTERNAL_API_ERROR), so I thought that the predicator can only work with ID, am I right?

Then if try it with anything else than a LABELS,I get the INVALID_PREDICATE_OPERATOR.

The IN operator doesn't fit my need, in fact, i'd like to retrieve all the AdgroupAd where a part of the URL may contain a pattern like this: "-12345.html", "-58754.html" etc..

Since we have many of this string to compare (maybe millons of it) it would take too much Get operation.

Thank you.

[Ray Tsang (AdWords API Team)]

Sebastien,

Please see the client library readme to turn on the logging.

Thanks,

Ray