14

I have a controller that makes a connection to a url to retrieve a csv file.

I am able to send the file in the response using the following code, this works fine.

    def fileURL = "www.mysite.com/input.csv"
    def thisUrl = new URL(fileURL);
    def connection = thisUrl.openConnection();
    def output = connection.content.text;

    response.setHeader "Content-disposition", "attachment;
    filename=${'output.csv'}"
    response.contentType = 'text/csv'
    response.outputStream << output
    response.outputStream.flush()

However I think this method is inappropriate for a large file, as the whole file is loaded into the controllers memory.

I want to be able to read the file chunk by chunk and write the file to the response chunk by chunk.

Any ideas?

shauneba
  • 2,122
  • 2
  • 22
  • 32
Julian Noye
  • 141
  • 1
  • 1
  • 3

1 Answers1

24

Groovy OutputStreams can take InputStreams directly with the << operator. The OutputStream will pull the data automatically with an appropriately sized buffer.

The following should efficiently copy the data, even if the CSV is quite large.

def fileURL = "www.mysite.com/input.csv"
def thisUrl = new URL(fileURL);
def connection = thisUrl.openConnection();
def cvsInputStream = connection.inputStream

response.setHeader "Content-disposition", "attachment;
filename=${'output.csv'}"
response.contentType = 'text/csv'
response.outputStream << csvInputStream
response.outputStream.flush()
ataylor
  • 64,891
  • 24
  • 161
  • 189
  • 3
    Good solution, but remember to close the inputStream as well. A safe alternative is to use connection.withInputStream{...} – stenix Aug 07 '15 at 09:16