Hi Ken,

For your reporting error (QueryError.PARSING_FAILED 
<https://developers.google.com/adwords/api/docs/common-errors#QueryError.PARSING_FAILED>
), it means that there maybe some incorrect syntax in your AWQL query. 
Kindly double check on your end if your syntax and spacing is correct. 
Based on your first code snippet, it seems that there is no space after *'WHERE 
CampaignStatus IN [REMOVED]',* so this could possibly be the cause of the 
error.  For your second code snippet, the syntax of setting predicates (see 
closing parenthesis and brackets) is incorrect.

You can refer to the two code snippets below (AWQL and non-AWQL) below that 
worked successfully on my end:

Using AWQL:

    $reportQuery = 'SELECT AdGroupName, CampaignStatus, AdGroupStatus '
        . 'FROM ADGROUP_PERFORMANCE_REPORT '
        . 'WHERE CampaignStatus IN  [REMOVED] ';


Using selector:

    $selector = new Selector();
    $selector->setFields(['AdGroupName', 'CampaignStatus', 
'AdGroupStatus']);
    
    $selector->setPredicates([
        new Predicate('AdGroupStatus', PredicateOperator::NOT_IN, 
['REMOVED']),
        new Predicate('CampaignStatus', PredicateOperator::NOT_IN, 
['REMOVED'])]);

 
Let me know if this helps.

Thanks,
Vincent
AdWords API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/a5d1c579-aa3e-455c-a620-404c08b64330%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to