PROHIBITED_FIELD_IN_SELECT_CLAUSE error

[Angelina Tkachivska]

Hi!

I am trying to pull "ad_group_ad.ad.image_ad.media_file" but it doesn't work, returns error:

Fault: errors {
  error_code {
    query_error: PROHIBITED_FIELD_IN_SELECT_CLAUSE
  }
  message: "The following field may not be used in SELECT clause: \'ad_group_ad.ad.image_ad.media_file\'."
}
request_id: "9xOXa56iGQaQZ0L-sI9VFA"

Query: "SELECT ad_group_ad.ad.image_ad.media_file  FROM ad_group_ad WHERE segments.date BETWEEN "2021-12-24" AND "2021-12-27"

It doesn't work to pull only "ad_group_ad.ad.image_ad.media_file" and also "ad_group_ad.ad.image_ad.media_file" with other fields from report.

Could you explain why it doesn't work and how I can pull this data?

[Google Ads API Forum Advisor]

Hi Angelina,

Thank you for reaching out to us.

Could you provide the full error message, which is usually included in the complete logs (request and response with request-id)? This will greatly help us identifying the error so we could provide guidance accordingly. Logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. 

You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Teejay Wennie Pimentel Google Ads API Team

ref:_00D1U1174p._5004Q2TlE39:ref