Upload CSV file to Salesforce using ADF/Azure Logic APPs

Question

Team,

I have a requirement which i need to upload a csv file to BULK API into salesforce environment, please suggest best option here, Can ADF web activity supports it or we need to implement it by using Azure logic apps.

Answer 1

Hi @Muralikrishna Pirla ,

Thank you for posting query in Microsoft Q&A Platform.

Azure data factory will be best option to go with here.

Azure data factory has Salesforce connector. Salesforce connector in ADF supports Copy activity as Source or Sink. That means, using salesforce connector you can copy data from or Copy data to Salesforce. Click here to know about all connectors available in Azure data factory

The Salesforce connector is built on top of the Salesforce REST/Bulk API. When copying data from Salesforce, the connector automatically chooses between REST and Bulk APIs based on the data size – when the result set is large, Bulk API is used for better performance; You can explicitly set the API version used to read/write data via apiVersion property in linked service.

Hence, explicitly making API call using web activity is not needed. Still if requirement demands to make explicit API call then we can use web activity. Thank you.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators