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 originalI 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 originalHi
Please post screenshots of how your Zap step is configured, thanks.
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
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.