It's possible to Export .csv files to HotFolder

[kleberaraujo]

I have a question regarding upload files to Hotfolder?

We have developed a cronjob to perform a flexible search on some entities and the result is included in a .csv file. The difficulty lies in being able to get this file and send this csv to a specific directory in the hotfolder so that it is available to another sector of the company. Is it possible to carry out this activity? Where can I get documentation or even a sample code so I can do this coding?

I am grateful for the help.

[a_e_dubey]

HI @kleberaraujo

Yes this is possible. So you have to create CSV data as per agreed header. TO generate csv you need to use some API as this is simple java implementation. Also you can refer sample reference: below link.

CSV Generation sample code

Also to copy or transfer this file to next location i.e hotfolder assuming S3 bucket. Please see below link:

Copy file to S3

If it is same server probably only File API will work to copy this file to specified location so it depends on server type whether it is linux or windows but only little syntax will differ in terms of path.

Copy file to a location

Also note that this is custom requirement so you have develop your own but you can refer step by step like create con job, create CSV file, Copy same file to hotfolder location.

I hope this will help you.