topic Re: tGoogleDriveGet 404 Not Found in Talend Studio

tGoogleDriveGet 404 Not Found

MattE — Fri, 15 Nov 2024 21:14:52 GMT

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,mimeType,fileExtension&supportsAllDrives=false

{

"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

Re: tGoogleDriveGet 404 Not Found

Anonymous — Mon, 20 Nov 2023 02:01:07 GMT

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

Re: tGoogleDriveGet 404 Not Found

MattE — Mon, 20 Nov 2023 11:36:54 GMT

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.

Re: tGoogleDriveGet 404 Not Found

Anonymous — Tue, 21 Nov 2023 01:21:23 GMT

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

Re: tGoogleDriveGet 404 Not Found

MattE — Tue, 21 Nov 2023 10:41:33 GMT

Yeah thanks - here's the job

Re: tGoogleDriveGet 404 Not Found

Anonymous — Wed, 22 Nov 2023 04:29:41 GMT

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

Re: tGoogleDriveGet 404 Not Found

Steve_Cannon — Thu, 09 Jan 2025 20:36:23 GMT

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.

Re: tGoogleDriveGet 404 Not Found

MattE — Thu, 08 May 2025 11:35:05 GMT

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.",