Need to replicatate the advance search results export feature using SDK or a better way.

We have a situation,

We need to generate a report and send this report to a FTP location.

Report details:

Report contains Item and its attributes alone with one level BOM and some BOM attributes.

So Saved Advanced search --> Formatted output --> Run the search --> Export as CSV

We need to send this CSV to a FTP location.

What is the best way to do this and send the report daily to the location.

We tried to use the SDK to do this and run the query and get the results and write results to the file and FTP the file.