I have been using talend for some time and I am usually able to find an answer to any question I have in these forums. However I could not find a solution to my problem which has lead me to create my very first post.
I have successfully made a connection and I am able to download files using tGoogleDriveGet such as pdf files or image files.. however I cannot download the Google spreadsheet that is generated from a Google form.
tGoogleDriveConnection ---> tGoogleDriveGet
Name of File: "QA Form (Responses)"
Save To: "/Users/me/Desktop/QA Form (Responses)"
Prefer to download in CSV format. Any assistance appreciated.
Thanks so much.
No need for authorization with tFileFetch. I'll try to write a simple tutorial:
1) Go to google drive, open the doc, in the top right section there is a SHARE button. Click that and change Link sharing to "Anyone with the link can view". This is a URL that will give access to view, to anyone that has the URL.
2) Create a tFileFetch component and input the URL except you must edit the url to contain "export?format=csv"
(Example: https://docsgooglecom/spreadsheets/d/LONG_ID_STRING/export?format=csv&id=LONG_ID_STRING ) Change to . and change LONG_ID_STRING to the ID in the share URL--it will be an alphanumerical number--mine was about 44 digits.
My plan is to simply download the file then read it later. A little bit crude but it works.