tGoogleDriveGet 404 Not Found

[MattE]

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

[Anonymous]

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]

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]

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]

Yeah thanks - here's the job

[Anonymous]

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]

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.

[MattE]

so funny i google this problem again and this thread of mine came top. Thanks @Steve_Cannon i missed your comment last time but you are 100% right. 

Anyone from Qlik any idea why these components are adding a period to the filename?

The filename is typed in as 1v0b2tF5Vhq78ox2dh1XMq4GQiMpx8P5rWzw6ztdSsJI but you can clearly see in the error that Talend is adding a period on the end

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