topic Re: Youtube Data connector in Connectivity & Data Prep

Youtube Data connector

gagan_chhabra — Wed, 22 Dec 2021 14:57:41 GMT

I have been using Qlik Youtube data connector for a while now. For previous 2-3 days, it started giving error that limit exceeded. Exact error message is:

There was an error running the table (Failed on attempt 1 to GET. (The remote server returned an error: (403) Forbidden.){ "error": { "code": 403, "message": "The request cannot be completed because you have exceeded your quota., "errors": [ { "message": "The request cannot be completed because you have exceeded your quota.", "domain": "youtube.quota", "reason": "quotaExceeded" } ] } } )

Looks like the API limit has been reached, but it is not resetting on its own and giving this error for last 2 weeks now.

Can anyone tell me how to reset the API limit for youtube data connector?

Re: Youtube Data connector

stevedark — Mon, 29 Jun 2020 11:46:19 GMT

Which connector are you using, is it via a QWC web portal (on 5555) or the connector that is native in Sense?

It was the case back along that all calls from Qlik, regardless of user, impacted on the quota. I'm not sure if this is still the case, but if so it may be nothing to do with what you are doing, rather than general usage of the connector is up.

Hopefully someone from Qlik will be able to shed more light.

Re: Youtube Data connector

gagan_chhabra — Tue, 30 Jun 2020 03:50:44 GMT

Hi Steve,

Yes it is QWC running at port 5555. It was running fine till 2 weeks back. Even if the quota exeeded , it would reset midnight pacific pacific time.

But now it is not resetting on its own.

Re: Youtube Data connector

stevedark — Wed, 01 Jul 2020 06:59:19 GMT

I'm not sure what would have changed then.

Do you have a solid incremental load with QVDs in place, so fewer calls to the API can be made?

Steve

Re: Youtube Data connector

gagan_chhabra — Wed, 01 Jul 2020 07:02:34 GMT

Hi Steve,

Even if limit is exceeded it should reset after the day. But its not. The issue here is not how to restrict to fewer API calls ,I guess.

Re: Youtube Data connector

NickBaker — Mon, 03 Aug 2020 10:38:49 GMT

Hi - there is a known issue with the YouTube Data connector - somehow the API quota limits were reset and we've not had any response from Google on the matter so far. We are actively working on a potential workaround for this but it will take some time to implement unfortunately.

Apologies for the inconvenience.

If you and any other users are still affected by this issue it would help to reply with a 'me too' or +1... that way we might be able to escalate it further.

Re: Youtube Data connector

Michiel — Wed, 16 Sep 2020 07:42:54 GMT

Hi Nick,

We're having the exact same issue at the moment. Are there any developments so far? Is there a forum / page where we can see the latest updates regarding this matter?

Thanks, Michiel

Re: Youtube Data connector

NickBaker — Wed, 16 Sep 2020 08:11:46 GMT

Hi Michiel,

We have identified the root cause: our YouTube GCP project required an audit for continued access but unfortunately the emails about this went to an unchecked email account (still not sure why this happened) resulting in the quota being reduced then revoked. We have submitted the audit form and have a contact at Google who is escalating the issue for us which will hopefully speed up what is usually a fairly protracted process. Hopefully once the audit is complete the quota limits will be reset immediately and the connector should start working again.

Again, apologies for the inconvenience, appreciate this is very frustrating. We'll post on this thread when we get any relevant updates.

Re: Youtube Data connector

chrisbrain — Wed, 07 Oct 2020 09:58:35 GMT

Unfortunately we were not successful and Google have not restored this connector's access.

We are now considering whether to reduce the functionality and try again to get it passed through YouTube's audit process.

If you are reading this and have been using the connector it would be useful if you could contact us (DM me or @NickBaker if you like) and let us know the use case and data you were running and we can then see if that is something feasible for us to consider in a future iteration of the connector.

Re: Youtube Data connector

gagan_chhabra — Wed, 07 Oct 2020 10:52:54 GMT

Hi Nick,

Is there any ETA to resolution of this issue? As we are already paying large sums for licenses of these connectors.

Re: Youtube Data connector

Ian_Crosland — Thu, 08 Oct 2020 11:51:41 GMT

Thanks for the feedback, we are still working very closely with Google to understand the new limitations imposed on the API's used within the connector and will post a response ASAP.

Re: Youtube Data connector

gagan_chhabra — Thu, 08 Oct 2020 14:39:43 GMT

Hi Ian,

I will be waiting for your response here.

Re: Youtube Data connector

P-O_Davidson — Tue, 27 Oct 2020 21:09:31 GMT

After careful consideration, we have decided to discontinue the YouTube Data Connector for the time being. The connector will be removed with the release in December.

As an alternative we recommend users trying the YouTube Analytics Connector, as we expect this to be sufficient for most current use cases.