05-23-2017 10:28 AM
Hi All,
Am trying to create two pipelines with below information,
SFTP Account created as Basic Auth,
User Name: ftpuser@52.86.106.54:22
File location path(sftp) which I verified is working when trying to access from browser,
Tried using google spreadsheet reader snap and could only see excel files but not csv. Is this the correct snap or should I use REST snap pack for it.
Thanks in advance!
-Arun
05-23-2017 11:07 AM
In the 4.x code line, there isn’t a ‘CSV Read/Write’ Snap. File Read to CSV Parser is the correct configuration. Performance issues may require Support to investigate.
I don’t believe the Google Spreadsheet Reader reads CSV files, but I will double check with Development.
05-23-2017 11:24 AM
Thanks!!
Even I tried below as per the file reader snap documentation,
For google drive access,
Can we use REST snap pack for accessing csv files on google drive. Is this the right approach now??
05-23-2017 11:25 AM
Mapper Snap properties for above reply on the pipeline
05-23-2017 11:30 AM
To use $filename in the File field, you need to toggle on the expression button (=). Without it, it is treated as a string.