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?
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.
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
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.