function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Michael MMichael M 

Send reports to FTP

Hello I have a couple reports I need to send weekly to via FTP. Is there a way to do this through scheduled apex? If not, what is the best free way to do it? 
Best Answer chosen by Michael M
AbhishekAbhishek (Salesforce Developers) 
Through the salesforce service (Apex or others) you cannot directly communicate with an FTP server (either upload or download).

Your best bet would be to use an external application. Jitterbit Data Loader (https://www.jitterbit.com/solutions/salesforce-integration/salesforce-data-loader/) is the go-to application for FTP interactions with salesforce.

You could also create your own service outside of the Salesforce platform.

For further reference, you can check this blog too,

https://salesforce.stackexchange.com/questions/57731/how-to-send-and-receive-data-from-salesforce-to-a-ftp-server/65938


I hope you find the above information is helpful. If it does, please mark as Best Answer to help others too.

Thanks.
 

All Answers

AbhishekAbhishek (Salesforce Developers) 
Through the salesforce service (Apex or others) you cannot directly communicate with an FTP server (either upload or download).

Your best bet would be to use an external application. Jitterbit Data Loader (https://www.jitterbit.com/solutions/salesforce-integration/salesforce-data-loader/) is the go-to application for FTP interactions with salesforce.

You could also create your own service outside of the Salesforce platform.

For further reference, you can check this blog too,

https://salesforce.stackexchange.com/questions/57731/how-to-send-and-receive-data-from-salesforce-to-a-ftp-server/65938


I hope you find the above information is helpful. If it does, please mark as Best Answer to help others too.

Thanks.
 
This was selected as the best answer
Michael MMichael M
Thanks Abhishek!!
Boris FrankBoris Frank
Hello. I use Skyvia (https://skyvia.com/data-integration/integrate-salesforce-ftp) for such goals. It automates CSV data loading between Salesforce and FTP with no coding. You need only configure your import/export in convenient GUI wizards and use flexible scheduling settings to automate data operations.