Hello Sabrina,
Apologies for not being specific.
I have tried tGSpreadsheetInput however I receive an error here regarding Authentication. I believe it may be due to oAuth2
Exception in component tGSpreadsheetInput_1
com.google.gdata.util.AuthenticationException: Error authenticating (check service name)
at com.google.gdata.client.GoogleAuthTokenFactory.getAuthException(GoogleAuthTokenFactory.java:553)
at com.google.gdata.client.GoogleAuthTokenFactory.getAuthToken(GoogleAuthTokenFactory.java:430)
at com.google.gdata.client.GoogleAuthTokenFactory.setUserCredentials(GoogleAuthTokenFactory.java:301)
at com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:324)
at com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:301)
at bd.testzone_0_1.testzone.tGSpreadsheetInput_1Process(testzone.java:805)
at bd.testzone_0_1.testzone.runJobInTOS(testzone.java:1292)
at bd.testzone_0_1.testzone.main(testzone.java:1141)
Here is the error tGoogleDriveGet I receive when I attempt to load the Name of File as: "QA Form (Responses)"
Exception in component tGoogleDriveGet_2
java.lang.IllegalArgumentException: java.net.MalformedURLException
at com.google.api.client.http.GenericUrl.parseURL(GenericUrl.java:638)
at com.google.api.client.http.GenericUrl.(GenericUrl.java:114)
at bd.testzone_0_1.testzone.tGoogleDriveGet_2Process(testzone.java:524)
at bd.testzone_0_1.testzone.tGoogleDriveConnection_1Process(testzone.java:429)
at bd.testzone_0_1.testzone.runJobInTOS(testzone.java:899)
at bd.testzone_0_1.testzone.main(testzone.java:748)
Caused by: java.net.MalformedURLException
at java.net.URL.(URL.java:619)
at java.net.URL.(URL.java:482)
at java.net.URL.(URL.java:431)
at com.google.api.client.http.GenericUrl.parseURL(GenericUrl.java:636)
... 5 more
Caused by: java.lang.NullPointerException
at java.net.URL.(URL.java:524)
... 8 more
Thanks so much for your assistance!
Al
edit:
when I print out to the console a tGoogleDriveList results, I can see all the pertaining documents in the google drive. Here I can see that talend is able to detect and list all the contents of the folder, including the QA form (google form) and the QA form responses (google worksheet) :
TGoogleDriveList global variables:
tGoogleDriveList_1_ERROR_MESSAGE: null
tGoogleDriveList_1_ID: 144HWZMpTVu5555555555naBR-npCUkhlXTJA
tGoogleDriveList_1_LAST_MODIFIED: 2015-10-29T20:35:57.263Z
tGoogleDriveList_1_MIME_TYPE: application/vnd.google-apps.spreadsheet
tGoogleDriveList_1_SELF_LINK:
https://www.googleapis.com/drive/v2/files/144HWZMpTVuzU555555555BR-npCUkhlXTJA
tGoogleDriveList_1_TITLE: QA Form (Responses)
TGoogleDriveList global variables:
tGoogleDriveList_1_ERROR_MESSAGE: null
tGoogleDriveList_1_ID: 1nEhtGqhxF8Iyz55555555555EPWtEHC9A
tGoogleDriveList_1_LAST_MODIFIED: 2015-10-27T22:06:43.955Z
tGoogleDriveList_1_MIME_TYPE: application/vnd.google-apps.form
tGoogleDriveList_1_SELF_LINK:
https://www.googleapis.com/drive/v2/files/1nEhtGqhxF8I5555555pLUEPWtEHC9A
tGoogleDriveList_1_TITLE: QA Form
TGoogleDriveList global variables:
tGoogleDriveList_1_ERROR_MESSAGE: null
tGoogleDriveList_1_ID: 0B5o655555555555lcl9maWxl
tGoogleDriveList_1_LAST_MODIFIED: 2014-08-13T22:32:12.144Z
tGoogleDriveList_1_MIME_TYPE: application/pdf
tGoogleDriveList_1_SELF_LINK:
https://www.googleapis.com/drive/v2/files/0B5o6HAN555555555lcl9maWxl
tGoogleDriveList_1_TITLE: How to get started with Drive
