How to list all ad accounts linked to a google ads account using a GAQL query (Google Ads Connector)?

[EduardoOliveira]

Hello, I would like to ask for your help. 

I am trying to bring data from a GAQL query, in order to list all ad accounts linked to my Google ads account. However, it is noted that to perform a GAQL query using the Google Ads API, it is necessary to inform an ad account id (example: customers/1234567890), which limits the search to a single account. In that case, how could this general listing be made?

*(I note that in the api interface itself, such functionality is presented in the accounts part, but limiting the choice to only 1 account as well).

The GAQL search query from that part would be this one correct, but how would this listing be done?

SELECT   

  customer_client.client_customer, 

  customer_client.id, 

  customer_client.level, 

  customer_client.manager, 

  customer_client.status, 

  customer_client.time_zone, 

  customer_client.descriptive_name 

FROM customer_client

Thank you for your attention!

[EduardoOliveira · Accepted solution]

I managed to solve it!

To list accounts through the Qlik native GoogleAdsAPI, it is necessary to connect the main email that is linked to the Ads Manager Account (https://ads.google.com/home/tools/manager-accounts/). In this context, the manager account is the one that has all the other accounts linked, so when the search is done using the management account ID through the Qlik API, the other linked accounts will appear together with it.!