Forum Discussion

mtran21's avatar
mtran21
New Contributor III
5 years ago

How to write an empty CSV file

I am looking for solution on how to write an empty data with headers csv file. I have a Oracle snap that execute a query then output to a csv file. I still want the csv file to be produced even the query returns zero record.
Here is my pipeline

2 Replies

  • jfpelletier's avatar
    jfpelletier
    Contributor

    Hello koryknick,

    Thanks for letting me know that we can output binary directly from the HTTP client, that's very good to know!

    So I tried that and unfortunately my resulting document is still not valid. Maybe my issue is the way that I retrieve the file? When I look at the preview to download the results, it says that the file only contains the 20,000 first bytes, which is not the correct size. What is the best way to download a file that I downloaded from the HTTP client?

    Kind regards,

    JF

     

    • jfpelletier's avatar
      jfpelletier
      Contributor

      I forgot to attach the screenshot of the results that I mentioned earlier: