Unable to query final_url_expansion_asset_view

2 views
Skip to first unread message

Remya Srinivasan

unread,
6:37 PM (3 hours ago) 6:37 PM
to (Deprecated) Google Ads API and AdWords API Forum
Trying to run this query:

SELECT final_url_expansion_asset_view.ad_group,
final_url_expansion_asset_view.asset,
final_url_expansion_asset_view.asset_group,
final_url_expansion_asset_view.campaign,
final_url_expansion_asset_view.field_type,
final_url_expansion_asset_view.final_url,
final_url_expansion_asset_view.resource_name,
final_url_expansion_asset_view.status,
ad_group.id,
ad_group.name
FROM final_url_expansion_asset_view
WHERE
final_url_expansion_asset_view.status = 'ENABLED'
AND campaign.status IN ('ENABLED', 'PAUSED')
AND ad_group.status IN ('ENABLED', 'PAUSED')
AND final_url_expansion_asset_view.field_type = 'DESCRIPTION'

Getting error:

google.ads.googleads.errors.GoogleAdsException: (<_InactiveRpcError of RPC that terminated with:
        status = StatusCode.INVALID_ARGUMENT
        details = "Request contains an invalid argument."
        debug_error_string = "UNKNOWN:Error received from peer ipv4:142.251.29.95:443 {grpc_message:"Request contains an invalid argument.", grpc_status:3}"
>, <_InactiveRpcError of RPC that terminated with:
        status = StatusCode.INVALID_ARGUMENT
        details = "Request contains an invalid argument."
        debug_error_string = "UNKNOWN:Error received from peer ipv4:142.251.29.95:443 {grpc_message:"Request contains an invalid argument.", grpc_status:3}"
>, errors {
  error_code {
    final_url_expansion_asset_view_error: MISSING_REQUIRED_FILTER
  }
  message: "At least one required filter has to be applied in the query."
}
​ 
It doesn't say what is the required filter

Reply all
Reply to author
Forward
0 new messages