Error Connect Google AdWords with Azure Data Factory using Linked Serivices

[Ivan Sanchez]

Hi,

I'm trying to connect AdWords to Azure Data Factory using Linked Services, but an error returns with the following message:

"Error code
9603
Details
ERROR [HY000] [Microsoft][GoogleAds] (62) API Connection Failed. Forbidden Request. HTTP Response code: 401
ERROR [HY000] [Microsoft][GoogleAds] (62) API Connection Failed. Forbidden Request. HTTP Response code: 401
Activity ID: 07172e33-560a-4d6b-ae6a-cf1b27d4fbb9."

Regards,

Ivan Sanchez - 

[Google Ads API Forum Advisor]

Hi Ivan,

Thank you for posting your concern. Allow me to provide support.

Upon checking the concern, it appears that you are using a third-party application. With this, I am afraid that our team would not be able to provide support to your concern as it is outside of our scope already. The reason is, even though it might be using Google Ads API on its backend, our team doesn't have access to its implementation and its inner workings. With this reason as well, we would not be able to investigate and address the issue there.

With this, I would suggest reaching out to the support team of this third-party application instead to get further assistance on this concern.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2fajQi:ref

[Serena MDW]

Hello Ivan, 

I have exactly the same error response from Linked Service trying to connect Adwords. Did you found how to solve this?

[Google Ads API Forum Advisor]

Hi,
 

Thanks for reaching out to the Google Ads API team. I hope you are doing well today.
 

Please note that this support channel can only provide assistance to issues/concerns related to the Google Ads API.
 

With regards to your concern, to further investigate this issue, could you please provide a full screenshot of the error you encountered and If you encountered an API error then provide the complete request and response logs with request ID and request header generated on your end? 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. I ask this so our team further investigates your concern and provides specific recommendations on the issue.

You can provide it via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.
 

Regards,

Darwin Google Ads API Team

ref:_00D1U1174p._5004Q2gRCkp:ref