Data Factory Linked Service - Google Ads

BobGang-3117 6

Getting an error :
ERROR [HY000] [Microsoft][GoogleAds] (30) Error with HTTP request, response code: 400. Message: Version v8 is deprecated. Requests to this version will be blocked.,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][GoogleAds] (30)

I am using the existing Google AdWords API, how does the Version get updated to Version 11?

3 answers

MartinJaffer-MSFT 26,106 Reputation points

2022-07-08T18:55:18.467+00:00
Hello @BobGang-3117 and welcome to Microsoft Q&A.

Since the GoogleAdWords was deprecated you need to open that linked service and swicth it to GoogleAds. See below.

https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-google-adwords#migrate-to-the-new-version-of-google-ads-api

Hope this will help. Please let us know if any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
Please sign in to rate this answer.
BobGang-3117 6 Reputation points

2022-07-08T19:57:17.177+00:00

hi @MartinJaffer-MSFT thank you for your reply.

I already did that, now the version is being deprecated. I believe the issue is with the Google AdWords pre-built linked service. everything worked until today with the version error.

https://developers.google.com/google-ads/api/docs/sunset-dates

BobGang-3117 6 Reputation points

2022-07-09T22:42:58.647+00:00

I created a new set of credentials in google api console. generated a new refresh key, everything connects, still getting same error

Error code 9603
DetailsERROR [HY000] [Microsoft][GoogleAds] (30) Error with HTTP request, response code: 400. Message: Version v8 is deprecated. Requests to this version will be blocked.
ERROR [HY000] [Microsoft][GoogleAds] (30) Error with HTTP request, response code: 400. Message: Version v8 is deprecated. Requests to this version will be blocked.
Activity ID: 8c15b4be-6c11-46a3-b4cd-3f15441f84a2

MartinJaffer-MSFT 26,106 Reputation points

2022-07-12T19:25:36.973+00:00

Thank you for clarifying @BobGang-3117 .

I admit I did not look as closely as I should have, and jumped to conclusions. Looking at the version link you provided, I do not even see version 8. Doing a quick search I found article link stating the sunset for 7 and 8 was May 11, 2022.

I'm looking into trying to repro your findings, but it looks like a deep hole (take a long time to do). I'll take your word for it and report this bug internally. If you would like, I'll also give you a 1-time free support ticket to help get this moving faster.

While it is odd that ADF apparently fell behind, it is even odder that I haven't seen someone bring this issue up before now. That's 2 months. Well, if you said it worked yesterday, maybe the actual shut-down at Google was later than the official sunset date?

Ah wait, I think I found one via a different channel.

BobGang-3117 6 Reputation points

2022-07-12T19:35:05.487+00:00

@MartinJaffer-MSFT The error first occurred 6/29 but I was able to rerun up until 7/8

Any direction at this point would be great.

MartinJaffer-MSFT 26,106 Reputation points

2022-07-12T22:00:29.46+00:00

I have sent off some email to light a fire. I believe you are correct in your assessment and there is nothing on the user side that can be done. Nowhere in the JSON definition of the linked service is there a place to specify the api version.

I hope to hear back in a day or two.

BobGang-3117 6 Reputation points

2022-07-12T22:03:59.137+00:00

Thanks Martin.

MartinJaffer-MSFT 26,106 Reputation points

2022-07-14T18:38:58.103+00:00

Hey @BobGang-3117 , just keeping you updated. That little fire I lit has grown into a large bonfire. This issue has been given a very high priority.

BobGang-3117 6 Reputation points

2022-07-14T20:36:27.99+00:00

That is great to hear @MartinJaffer-MSFT You rock!

BobGang-3117 6 Reputation points

2022-07-19T19:32:18.317+00:00

@MartinJaffer-MSFT , any updates from the engineering team?

MartinJaffer-MSFT 26,106 Reputation points

2022-07-21T17:33:01.473+00:00

Yeah, they are now in the process of testing a fix before deploying. From the sounds of it this may be a hotfix rather than regular update, so really really soon. @BobGang-3117

Gigi Giorgobiani 5 Reputation points

2023-05-30T23:41:02.52+00:00

Hi, i am trying to add google ads linked service, but there is only adwords, without change switch for google ads.

what is option ?
ADF

BobGang-3117 6 Reputation points

2023-05-31T23:14:37.06+00:00

Its the same service, Google Ads — formerly known as Google AdWords.

I am successfully connecting.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
MartinJaffer-MSFT 26,106 Reputation points

2022-08-01T16:43:06.33+00:00

I think the fix has been deployed
Please sign in to rate this answer.
BobGang-3117 6 Reputation points

2022-08-01T16:48:59.85+00:00

Do I have to recreate the linked service, I am still getting same error when I try to connect "Message: Version v8 is deprecated. Requests to this version will be blocked."
Update: I did recreate the service and still getting error.

BobGang-3117 6 Reputation points

2022-08-03T20:21:55.047+00:00

@MartinJaffer-MSFT Any update?

BobGang-3117 6 Reputation points

2022-08-11T09:26:35.077+00:00

@MartinJaffer-MSFT Any Updates?

MartinJaffer-MSFT 26,106 Reputation points

2022-08-23T21:11:22.34+00:00

Sorry I didn't respond @BobGang-3117

I would like to give you a support ticket, as this is getting beyond my ability to resolve. The Support engineers will be able to look into your logs and find the cause.

Instructions coming in private message.

MartinJaffer-MSFT 26,106 Reputation points

2022-08-24T18:26:49.91+00:00

I was wrong. The fix has not been deployed.

I followed up with the developers. I heard back today. The driver has not been released yet. There were problems, and the current version is still outdated.

My apologies @BobGang-3117 . I made assumptions.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
BobGang-3117 6 Reputation points

2022-08-24T18:46:53.737+00:00

@MartinJaffer-MSFT thanks for the update and support ticket, I receive this error on trying to create a ticket "Your cloud service provider manages your subscription.

To submit a technical support request for this subscription, please contact your service provider:"

I was able to create a python script in PowerShell, that pulls in the data and loads to Azure Blob, problem is I don't know how to schedule it to run, so I daily manually call it in PowerShell.
python ./get_adwords.py -c xxxxxx > ./InputFiles/yesterday.txt;python upload_adword.py
Please sign in to rate this answer.
MartinJaffer-MSFT 26,106 Reputation points

2022-08-30T16:56:00.213+00:00

@BobGang-3117
So that message means you didn't get your Azure subscription directly from Azure. Instead you went through a ... is retailer the word? Anyway, this middle-person is someone you need to talk with.

There are a number of ways to have your script run daily. First it depends where you are running the script (on your personal computer / Azure VM, or on other Azure service).

If your personal machine or VM is linux-based, you would set up a cron job. If windows-based, you can use Task Scheduler (there are how-to videos on youtube).

If you are running in Azure service, it could be anything from Azure Automation, to time-based Azure Function , to Data Factory scheduled trigger using Custom Activity to run your code on Azure Batch. Most services on which you can run your script have a scheduling option.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Data Factory Linked Service - Google Ads

3 answers

Your answer