Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
MattE
Creator II

tGoogleDriveGet 404 Not Found

I've set up a tGoogleDriveConnection with the OAuth Method and that works as far as i can tell. However, tGoogleDriveGet returns a 404 error when trying to get a file by Id which i know exists. Also tGoogleDriveList returns nothing and no error.

The service account have access to the drive in question.

Any ideas?

Studio 7.3.1-R2022-06

Exception in component tGoogleDriveGet_1 (google_docs)

com.google.api.client.googleapis.json.GoogleJsonResponseException: 404 Not Found

GET https://www.googleapis.com/drive/v3/files/1v0b2tF5Vhq78ox2dh1XMq4GQiMpx8P5rWzw6ztdSsJI?fields=id,mim...

{

 "code" : 404,

 "errors" : [ {

  "domain" : "global",

  "location" : "fileId",

  "locationType" : "parameter",

  "message" : "File not found: 1v0b2tF5Vhq78ox2dh1XMq4GQiMpx8P5rWzw6ztdSsJI.",

  "reason" : "notFound"

 } ],

 "message" : "File not found: 1v0b2tF5Vhq78ox2dh1XMq4GQiMpx8P5rWzw6ztdSsJI."

}

at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:146)

at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:118)

at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:37)

at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:428)

at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1108)

at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:514)

at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:455)

at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)

at org.talend.components.google.drive.runtime.GoogleDriveUtils.getMetadata(GoogleDriveUtils.java:122)

at org.talend.components.google.drive.runtime.GoogleDriveUtils.getResource(GoogleDriveUtils.java:456)

at org.talend.components.google.drive.runtime.GoogleDriveGetReader.start(GoogleDriveGetReader.java:72)

at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)

at unidays_main_project.google_docs_0_1.google_docs.tGoogleDriveGet_1Process(google_docs.java:1730)

at unidays_main_project.google_docs_0_1.google_docs.tGoogleDriveConnection_1Process(google_docs.java:1156)

at unidays_main_project.google_docs_0_1.google_docs.runJobInTOS(google_docs.java:3145)

at unidays_main_project.google_docs_0_1.google_docs.main(google_docs.java:2419)

[FATAL]: unidays_main_project.google_docs_0_1.google_docs - tGoogleDriveGet_1 404 Not Found

Labels (2)
6 Replies
Anonymous
Not applicable

Hello,

Which OAuth method are you using to access to Google Drive? Are you getting any connection error after you make all the necessary configurations on google side while you test the connection?

Best regards

Sabrina

MattE
Creator II
Author

Hi @Xiaodi Shi​ thanks I'm using the service account method. No error on the tGoogleDriveConnection component, it completes with OnSubjobOk and moves onto the tGoogleDriveGet component which produces the 404 error.

Anonymous
Not applicable

Hello,

Would you mind posting your job design screenshots on community which will be helpful for us to understand your current situation and address your issue?

Best regards

Sabrina

MattE
Creator II
Author

Yeah thanks - here's the job

0695b00000skWrPAAU.png

Anonymous
Not applicable

Hello,

As Google Drive API requires that users are authenticated, you are able to download or upload files into it?

https://developers.google.com/drive/api/v3/about-auth

Best regards

Sabrina

Steve_Cannon
Contributor

I'm having the same problem.  Issue for me is not authentication.  The issue is that the tgoogledriveget compenent is adding a period ('.') to the id in the url which changes it.  Looks like that is happening to yours as well.