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 q...
Forum Discussion
To fix the SQL EXECUTE error we changed the Query Type from auto to read and the ID was returned. We have a feature request change into SnapLogic for the SQL INSERT snap. Would like the option to return the ID in this snap as well.
Hi @2020,
Should you try and add an entry in the Binary header properties section of the JSON Formatter Settings, like so:
then you should be able to use it in the File Writer, like so:
Hope this helps.
BR,
DimitriHi @2020,
To be fair, I tested the solution in my previous response by writing to sldb.
So I see now that the path in the File Name property in my response won’t work, because the format differs from the one in the example in the File Writer documentation.
I don’t have access to the Groundplex of the organization I used to test my answer. So I can’t test by writing the file that way.
As for the SMB protocol, I do use it in my work, but the path I use has a valid URL of a company server.
My guess is, when you are trying to write to the file system on the Groundplex, perhaps you lack permissions, or you maybe even have a stray quote sign in your path.
I’m sorry I can’t be of more help.
BR,
DimitriThank you
it`s ok you can close this thread.
