Error creating Google Drive Source and performing OAuth override

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Encountering errors while creating Google Drive Source programmatically and performing OAuth override. Issue with value not found error and 500 Internal Server Error. Need to use own Google client credentials.


Question

I have a use case for using Google Drive Source connector programmatically, with OAuth using my own google client Id and credentials.
While trying to create the source programmatically, I get the error:

    "status": 400,
    "type": "<https://reference.airbyte.com/reference/errors>",
    "title": "value-not-found",
    "detail": "The submitted value could not be found.",
    "documentationUrl": null,
    "data": {
        "value": "google-drive"
    }
}```
I have all the fields using the Airbyte API refernce. However, this gets fixed when I remove the sourceType from the request, and instead add definitionId in the request by fetching it from the metadata of the connector in airbyte github repo.

This helps me create the source, howevever, while creating the connection with the source created using this method, I am getting the 500 Internal server Error, and while checking the source on the Web app, I realised it was because of not performing OAuth Override for the source.

Now, the main issue is while performing the OAuth override for Google-drive.
I am getting the same value not found error, received while I was trying to create the source adding the sourceType in the request.
However, trying to add the definitionId in the request, instead of name for the OAuth override request doesn't work.

I don't know why the API is giving an error while I am trying to create source or perform OAuth override for the google-drive connector.
The same is working perfectly for the google sheets connector. The difference in both connectors is that GDrive is in marketplace while Google Sheets, inherently is supported by Airbyte.

How can I perform OAuth override for Google Drive given the error I am encountering? I have a strong need to use my own google client credentials.
Any help in this regard would be greatly appreciated.

Thanks!

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1720775092883679) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["google-drive-source", "oauth-override", "error", "api", "connector"]
</sub>