why querybook Extensions exmample doesnot work?

[Su Feng]

I used googleAdsServiceClient.search in java to query the example sql.. but return zero list in response;

SELECT extension_feed_item.sitelink_feed_item.line1,
  extension_feed_item.sitelink_feed_item.line2,
  extension_feed_item.extension_type,
  campaign.name,
  ad_group.name,
  extension_feed_item.status,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM extension_feed_item
WHERE segments.date DURING LAST_7_DAYS
  AND extension_feed_item.status != 'REMOVED' 

but in UI ,there is indeed a lot of data. why this happens?I think there is no problem with my query call, because other SQL can return the required data normally

[Google Ads API Forum Advisor]

Hello,

Thank you for reaching out to us.

I've also checked the provided query via the Query Validator and can confirm that there is no issue on the said query. So our team can also check this on our end, can you share to us the following details below?

• Customer ID
• complete logs (request and response with request-id)

In the Google Ads API, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.

Please send the requested details via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,

Mark Kevin Albios Google Ads API Team

ref:_00D1U1174p._5004Q2OUDT6:ref