I have a Zap set up between Zendesk and s3, but when grabbing the file from s3 the file is being created as a full text file. Does anyone have advice on configuring the file to be transferred as a .csv?
Best answer by SamB
View original
File added to Amazon S3 as text instead of CSV
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+11
- Community Manager
- 4610 replies
-
21 September 2021
- Answer
Just wanted to follow up here as in the screenshot it looks like the Mimetype field hasn’t been specified. This may well be why Amazon S3 was having some trouble reading the file as a CSV.
Setting the Mimetype field to be text/csv should help to let Amazon S3 know that it’s a CSV file that’s being uploaded.
If that doesn’t work, then it may be worth uploading the file to another app first to generate the CSV file before sending it to Amazon S3. For example, you could use an app like EasyCSV to create the CSV. Then in the File field on the Amazon S3 step, you’d select the file generated from the EasyCSV step.
Userlevel 1
- Beginner
- 1 reply
-
26 July 2021
This post has been edited by a moderator to remove sensitive information. Please remember to obfuscate any personally identifiable information prior to posting as this is a public forum.
I have created a partial workaround using | as a delimitator, but would prefer the file uploaded to actually be .csv file type
Userlevel 7
+14
- Certified Zapier Expert
- 24086 replies
-
25 July 2021
Hi
Please post screenshots of how your Zap step is configured, thanks.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.