Empty CSV File With Header Row
I have a need to write an “empty” CSV file that includes only the header row information in the case that there’s no data to populate the file. Does anyone know a good way to do this? Anything to do ...
Forum Discussion
Thanks tstack. That’s what we ended up implementing. Agreed, it is not great, especially for a document with dozens of header columns.
For others whom happen to search for this as I just did. The router approach is still required as far as I can tell for the “No Data” condition, but, an easier way to write a header only file is to parse your JSON and use a Constant with a File Writer. For example, the following will get a list of Keys from your JSON (headers) as an array, turn it into a string, then, remove the opening and closing brackets.
JSON.stringify(Object.keys($)).replace(“[”,“”).replace(“]”,“”)
You can drop that into a Constant Snap and write to file. Works well for this case.
Can you share a screenshot of your pipeline that handle this? from the router.
I am in the same situation. I need to write an empty with header CSV file if there is no input data.
ThanksI was just looking at this oddly enough. It is a simple POC I built for another team. The issue was that, sometimes, the object was not updated in Salesforce since the last run and returned null. So, uncheck “Ignore Empty Result” in the Salesforce Read, make sure the Mapper is Null Safe, and have the Router look for your key value. If it finds it, carry on as normal. If it does not, parse the object keys and write with the constant as I posted prior.
Mine looks a bit different. I left outer join my input stream with my static header row and evaluate for the presence of data in my router. Then I either remove the unnecessary header data element or map the header row data to the variable name expected downstream for the data, and union back together.
I have a lot of stuff going on downstream to also add a single column “end of file” footer row, which was also a real pain in the butt.
