ETL workflow

[OS]

Hello, ads api team

I'm new here and didn't find anything similar. I need to create Google Ads - Internal DB pipeline based on Google Ads API. The pipeline should be fully automated w/o human interaction and run hourly. I already managed how to get data from test accounts, but not clear how to put all together. 

Here is how i see it:

1) obtain refresh_token using curl and generate_user_credentials.py

2) obtain access_token using refresh_token from previous step

3) call API method with access_token and developer_token

Is this correct approach? 

Also, it's been 3 days since i've applied for basic account but the request is still pending? How long might it take?

Thank you

[Google Ads API Forum Advisor]

Hi,

Thanks for reaching out to Google Ads API Forum.

With regards to your concerns, allow me to address the following below.

“I need to create Google Ads - Internal DB pipeline based on Google Ads API”

• Can you provide more context as to what you are trying to implement using the Google Ads API?

“Refresh Token”

• You may refer to the Get an OAuth2 Refresh Token and Configure Your Client documentation and learn how to get your refresh token. Please note that an OAuth2 refresh token is used to automatically renew OAuth2 access. 

“Access Token”

• You may refer to the Authorization with REST documentation to see how to generate an access token with REST and use that access token to authenticate to the Google Ads REST API.

“API call structure”

• You may refer to the API Call Structure documentation for more information on how to make a request using the API. Please note that if your developer token is pending approval, it can only be used to access test accounts. In that case, make sure the login customer ID value in your client library config is set to your test manager account ID, and the customer ID parameter in the Get Campaigns example is your test account ID.

Links included in this email:

• Get an OAuth2 Refresh Token and Configure Your Client - https://developers.google.com/google-ads/api/docs/first-call/refresh-token 
• Authorization with REST - https://developers.google.com/google-ads/api/videos/catalog/working-with-rest-2 
• API Call Structure - https://developers.google.com/google-ads/api/docs/concepts/call-structure 
• First Call: Get Campaigns - https://developers.google.com/google-ads/api/docs/first-call/get-campaigns 

With regards to the Basic access level request, please note that with regards to concerns related to the granting and approval process of these tokens are already outside of the scope of the Google Ads API support team as our team specializes in Google Ads API-related concerns and technical implementations only. To ensure you get proper assistance, we are reaching out to the Google Ads API Compliance team on your behalf.

In addition, can you provide the Case ID and Google Ads manager account (MCC) ID so that the Compliance team can further assist you with your concern?

@Compliance Team
Please find the pertinent details below and confirm if you are able to assist.

Summary:

The customer submitted an application to apply basic access to the Google Ads API but not yet received any updates. The customer is asking for updates on their request for basic access. 

• Case ID : (requested)
• Google Ads manager account (MCC) ID : (requested)

 

This message is in relation to case "ref:_00D1U1174p._5004Q2lv5j6:ref"

Thanks,
 

Google Ads API Team