Google ads API using Rest interface in ADF

[Manoj Ps]

Hi all, 

             I would like retrieve data from google ads account using Rest API in Azure data factory .

I have all the details with me for API call 

1.Client customer id

2. Client Secret

3. Refresh token 

4. Access token

5.Developer token

I have 2 questions.

1)I have google ads linked service in azure data factory ,but i could find proper document to use the google ads linked service to fetch the data from google ads

2) If i use Rest API , what is the best approach , should i use sql query or any other format .

kindly give some examples how to use it .it would really helpful. Thanks

Kind Regards

Manoj PS

[Google Ads API Forum Advisor]

Hi Manoj,

Thank you for reaching out to Google Ads API support. Here's our REST Interface guide and here are our samples for reporting called 'Search'. We support REST using a Bash Terminal and I can guess we can be helpful when translating to other environments.

Here's our Google Ads Query Language and Reports guides, every report type has it's own query generator that you can create correct reports with.

To get up and running we have a Quickstart guide with the REST interface Authorization and HTTP Headers guide instead of using a client library. We also have a Google Ads Developer Starter Checklist. 

Feel free to reach out to us.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2dnYEJ:ref