Access Adwords API from ETL program

[Niyas Raja]

Hi,

In my project, we are required to extract Adwords data using Adwords API using Azure Data Factory (Orchestration/ETL tool in Azure). This needs to run without asking for user consent as the jobs are running in the background. 

Can you please help with the steps involved in authorisation without asking for user consent?

Thanks,

Niyas

[Google Ads API Forum Advisor Prod]

Hi Niyas,

Thanks for reaching out. You actually don’t need to worry about asking for user consent and pulling data from the Adwords API. Your system would be able to continually get authentication by using the refresh token mechanism and the data would be pulled whenever your system makes the request against the Adwords API.

Please let me know if you have any further concerns.

Thanks and regards,
Xiaoming, Google Ads API Team

ref:_00D1U1174p._5001UKO0Kd:ref

[Niyas Raja]

Hi Xiaoming,

Thanks for your response. I did go through the link you sent across. I can see user consent is required to obtain the authorisation code. This code is then used to obtain refresh token. Can you please confirm if obtaining the authorisation code is a one time activity and the authorisation code does not expire?

Thanks and Regards,

Niyas

[Google Ads API Forum Advisor Prod]

Hi Niyas,

The user consent is just one time activity that occurs when you set up the credentials for OAuth2 for the first time. OAuth2 access tokens expire after a limited time. For this reason, the client libraries use the OAuth2 refresh token to automatically regenerate the OAuth2 access token. You could refer to this documentation for more details.

I hope this helps. Please let me know if you have any further concerns.

Thanks and Regards,

Xiaoming, Google Ads API Team

 

ref:_00D1U1174p._5001UKO0Kd:ref

[Niyas Raja]

Thanks Xiaoming. It works. I didn't realise setting up the refresh token is an one time process.

Regards

Niyas