1

I want to read a csv file from SFTP server and using that i need to update records or mark checkbox field true in Salesforce. This needs to be scheduled to run everyday. Can you please suggest a better approach for this? Don't want to use informatica cloud/ Jitterbit Data Loader.

Few method i thinked use Command line data loader inside FTP server to push the data into salesforce?

2
  • Perhaps you can schedule an apex class to fetch the csv file and process it for you?
    – Kasper
    Aug 13, 2015 at 13:42
  • Thanks.@Kasper File is on FTP update every day need a automatic scenario read file on FTP update records in Salesforce..... Aug 13, 2015 at 13:46

1 Answer 1

2

You can't access files(either upload or download) from FTP in Apex Code or other from Salesforce.

Your best bet would be to use an external application. CastIron, Dell Boomi is the go to application for FTP interactions with salesforce.

Also you can create your own webservice outside of the salesforce platform and call it from Apex.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .