We are trying to work on an automation where Salesforce Bulk API is being called.
We are hoping to use the Salesforce Bulk API activity in Studio, but I am confused about the setup. I have checked the documentation, but it does not provide any examples and I have also not been able to find a video that shows how to set up or use it. My use case is that I want to bulk insert certain records in Salesforce.
I have created a csv file with just one column “Name” and the Object is “Account”, we tried multiple objects like “case”, “Opportunity” but none worked.
I created a Salesforce Application Scope and tested my connection to Salesforce. It’s looking good. Then I added a “Create Bulk API Job” activity and “Start or Abort Bulk API job” activity.
I set the properties as such: columndelimiter: Comma, LineEnding: LF, Object: “Account”, and ID: “SFID”.
When I run the file, I don’t get any errors, but my Salesforce records are not getting updated. I am not sure what I am missing here. The status comes out as TRUE always with no error.
I even tried giving the custom server’s name as mentioned in below link but no luck.