@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.