YouTube Analytics Airbyte connector not working?

[fatchat]

Set up directly in the Airbyte UI

[himanshudube97]

@fatchat The youtube airbyte connector was done, but have to look the facebook-airbyte connector too, so keeping the status in progress.

Important: This command can only be run by one of the repository admins:
Usage: ./tools/bin/get_repo_admins.sh <personal_access_token>

[himanshudube97]

@fatchat
While setting up the YouTube connector in Airbyte, I encountered an error indicating that my YouTube account was invalid or inactive. This was likely because my YouTube account doesn’t have any activity, which may be required to successfully create a reporting job.

According to the Airbyte documentation, a reporting job must be created before YouTube can start generating reports. Airbyte is supposed to either create this job automatically or use an existing job if one is already present. However, in my case, Airbyte failed to create the reporting job and returned an error instead.

Steps Taken:
Initial Setup Failure: I tried adding my YouTube account as a source in Airbyte, but it resulted in an “invalid and inactive account” error. This seemed to be related to the lack of activity on my account.

Manual Job Creation: I manually created a reporting job using Google’s YouTube Reporting API through cURL commands:

API Endpoints Used:
https://youtubereporting.googleapis.com/v1/reportTypes
https://youtubereporting.googleapis.com/v1/jobs
https://youtubereporting.googleapis.com/v1/jobs/reports
After creating the job manually, I was able to successfully add my YouTube account as a source in Airbyte.

My Observations and speculations:
The Google APIs are functioning correctly since they returned valid responses when called directly via the command line.
The issue appears to be with Airbyte’s YouTube connector. It doesn’t seem to handle scenarios where a YouTube account has no existing activity. In such cases, Airbyte fails to create a reporting job, leading to the “invalid and inactive account” error.
Once I created the reporting job manually, Airbyte was able to proceed without any issues, indicating that Airbyte might not be adequately handling the creation of reporting jobs for inactive or low-activity YouTube accounts.

The error is manually coded here. https://github.com/airbytehq/airbyte/blob/9eccb244e7b521048f8382ce0e651da0d089f502/airbyte-integrations/connectors/source-youtube-analytics/source_youtube_analytics/source.py

P.S-> When i added the Shujaaz youtube account , it was immediately added. So acc to me, If the account is active and has analytics data eg views, comments etc in that case there is no error.

Important: This command can only be run by one of the repository admins:
Usage: ./tools/bin/get_repo_admins.sh <personal_access_token>