โ07-31-2019 02:34 PM
Iโm trying to read/download a CSV file from google drive. Iโm able to get the web content link but unable to download the file using it. Can anyone suggest how to download a file using the REST Get?
Solved! Go to Solution.
โ08-07-2019 11:53 AM
It looks like it is returning CSV data, you need to change the โResponse Entity Typeโ to TEXT or BINARY.
It is trying to interpret the result as JSON or XMLโฆ
โ07-31-2019 08:29 PM
Any reason yopu are using REST Get? If you have an HTTP URI, then why not use the File Reader with the URI, which then feeds into the CSV parser?
โ08-01-2019 04:41 AM
I have tried using a File Reader snap, it didnโt work.Donโt we need to pass authentication to download the file from a google drive?
If I try to open URI in a new tab it is asking for the gmail credentials. If I logged in then the file is downloading. I canโt provide any credentials if I use file reader.
โ08-06-2019 04:24 PM
Google Docs is not the same as Google Storage. We support Google Storage in the binary snaps using the gs:// protocol. For Google Docs/Spreadsheet etc, they are made for web interaction, and not direct access to the data. Which are you attempting to use?
(It is a subtlety, so a pedantic approach is required)
Thanks.
โ08-06-2019 04:54 PM
Trying to Read data from a CSV file uploaded into a Google Drive.