Hi, Thanks for your response. The formatting issue picked up by the Query Builder happened due to copy & paste of the string here. However, the query is formatted correctly in our code and is running correctly in production. In any case, the issue is still there even if we remove all the WHERE conditions. Please run the below query on the accounts we mentioned and you will see that no sitelinks are returned when infact the account has a lot of active sitelinks.
*SELECT asset.policy_summary.approval_status, campaign_asset.campaign, campaign_asset.resource_name, campaign_asset.field_type, campaign_asset.status FROM campaign_asset * Please advise. Oliver On Wednesday, May 4, 2022 at 5:26:52 PM UTC+1 adsapi wrote: > Hello Oliver, > > Thanks for reaching out to the Google Ads API forum. I would like to > inform you first that I am going to delete your initial post as it contains > sensitive information. I just pasted the context of your concern below > without the sensitive information: > > > > I have checked the GAQL query you shared into the Google Ads Query Builder > <https://developers.google.com/google-ads/api/fields/v10/query_validator?hl=en> > > page for the query validation on Google Ads API, the query got invalid > because of the reason format issue – “Malformed operand: "(ENABLED)AND > asset.policy_summary.approval_status NOT IN (\'DISAPPROVED\')". Filtering > conditions on the "campaign_asset.status" field using the "IN" operator > must contain an operand that takes the format of parentheses containing a > comma separated list of enum values on the field campaign_asset.status. The > following are valid enum values: ENABLED, PAUSED, REMOVED, UNKNOWN”. > > Please find the attached screenshots to your reference to fix the query > and call the Ads API again. Hope this information helps. Give it a try and > let me know if you have any questions on this. > > Best regards, > [image: Google Logo] > Jakeia Sabrina > Google Ads API Team > > ref:_00D1U1174p._5004Q2aPyIb:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/506bfc70-ebd4-4599-996d-ca680c04c20an%40googlegroups.com.
