V17: PROHIBITED_FIELD_COMBINATION_IN_SELECT_CLAUSE

[Keith Dale Cordova]

Hi Team, 

Our code needs to get both product_link.data_partner.data_partner_id and product_link.merchant_center.merchant_center_id on product_link table but encountering and error that needs to just select one of them after upgrading it from v15 to 17.

any recommendations on the sql how to fetch those data? here is our sample sql. Thanks

select product_link.type, product_link.product_link_id, product_link.data_partner.data_partner_id, product_link.merchant_center.merchant_center_id from product_link

[Google Ads API Forum Advisor]

Hi, 

Thank you for reaching out to the Google Ads API support team. 

Kindly note that as per the product link document, you can either use data_partner or merchant_center as a linked_product at a time in V 17 and it is not possible to use them together. Because of which you are getting the error message as "The following pairs of fields may not be selected together: product_link.data_partner.data_partner_id, product_link.merchant_center.merchant_center_id".

I hope this clarifies your issue. If you have any more concerns related to Google Ads API, please feel free to reach out to us.

This message is in relation to case "ref:!00D1U01174p.!5004Q02vGcUu:ref" (ADR-00270773)

Thanks,
 

Google Ads API Team