Result from Query

[Akash Prajapati]

Hi Team 

 When I am printing in the below manner - 

"try:
        for batch in stream:

             for row in batch.results:
                      print(row)
 I am missing some of the columns in my output for example like below even when I have selected them in the  main Query.
        metrics.video_quartile_p100_rate,
        metrics.video_quartile_p25_rate,
        metrics.video_quartile_p50_rate,
        metrics.video_quartile_p75_rate,

But when I print each column row.x, row.y then they are fetched in the result set.

"try:
        for batch in stream:

             for row in batch.results:
                      print(row.metrics.video_quartile_p100_rate)
   


Can you explain why there is a difference between these two methods, when row has all the columns from the query?

[Google Ads API Forum Advisor]

Hi Akash,

Thank you for reaching out to our API support team.

So that our team may take a closer look at the issue you encountered, could you also provide to our team the complete request and response logs, with the request-id and login-customer-id?

If you haven't yet, 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 may then send the requested information 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.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2W4x3M:ref

[Akash Prajapati]

Hi Team
Is this behaviour expected from the api ?

[Akash Prajapati]

Hi Team,

There is no error for which I can provide you the logs, I am asking that why is it happening when we print(row) the columns are missing even when the columns are present in the select query. But when I am using print(row.x) then that column is fetched, how to proceed on this ?

[Akash Prajapati]

hi team 
can you please provide any update

[Google Ads API Forum Advisor]

Hi Akash,

Since you mentioned that you are missing said columns in your output even though you have selected in your GAQL. In order to troubleshoot further, our team would need complete logs as requested by my colleague (Peter), so that we can check observed behavior. Kindly provide the requested information via Reply to author Privately option.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2W4x3M:ref