@Jaketh13 Thanks for the response, and I had considered this as a solution. Unfortunately that won't quite work for two reasons:
1. The file is actually a csv in a compressed .zip folder.
2. The file does not always have the same name, and I get the file name from the response to the http request placed in the custom connector.
Not sure if you figured this out, but the CSV Advanced should solve your problems.