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
Richie LandinghamRichie Landingham 

Upload Local Excel Documents to Salesforce Via DataLoad API.

Hello!,

I was wondering if anyone has any experience with this, or if anyone knows if this is even possible?

We get an excel document automatically created on our local server every day with information we have pulled via another API (That we can't intergrate directly with Salesforce).

What we want to do, is every day at X Time take the excel sheet, and upload it to salesforce using a mapping into a custom object.
 
Has anyone encounted a need to upload a CSV automatically like this? Would love to hear some potental ideas as well.
Best Answer chosen by Richie Landingham
Akhilesh Reddy BaddigamAkhilesh Reddy Baddigam
Hi Richie this might help (https://developer.salesforce.com/page/Using_Data_Loader_from_the_command_line), plese take a look and let me know.

If this helps you, please choose this as best anwer thank you!