function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Nail SNail S 

How to get the .csv file from external system using FTP to salesforce ?

Hello Experts,

Here i walk through some research and got to know is salesforce does not support direct FTP to get the file from external system, is there any code to get that .csv file from external system to salesforce (because i need sync that file for insert data to my salesforce and schedule it as well)..

have you guys any sample code and or flow to get this done ?

-Nail
JeffreyStevensJeffreyStevens
If the external system can email - you could use an email handler.
Nail SNail S
Hey Jeffrey,

if i'm not wrong, you meant they need to set email alert with attachment of that file and send it to salesforce and salesforce will get that file from attachment and do scheduling ?

-Nail
 
JeffreyStevensJeffreyStevens
Yep.  If the system that has the CSV file can email it - then you can receive it in salesforce, and write a class to process it.
SergeiSergei
I think you can use Skyvia to integrate Salesforce with the CSV file stored in FTP. This functionality is free. You will need to set up the connections to you Salesforce and FTP accounts, map the necessary fields, and specify the scheduling time. Read here (https://skyvia.com/connectors/salesforce)the section "Import and Export CSV Files".