CODEWITHSUNDEEP
salesforcemule4mule-component
Sunny85
Sunny85

Reputation: 67

How to achieve bulk update ( contact object) to Salesforce from Mule 4 API

I have a requirement to update employee fields in salesforce (update only, not creating a new one if not present - upsert) using contact object/type.

I am able to update it successfully using the Mule flow and connectors shown in the screenshot below, however I want to do the update in Bulk (for 200 records at once).

Currently I am calling query connector to getting the salesforce id, then construct the payload and do the actual update. Is there any way to update this in a single call? I know there is one to one mapping of employee id to salesforce id, but can we achieve it using a single connector? The reason we want to move to this approach is - since the records are getting more and more every day, its taking longer time and make it more efficient.

Let me know if anything in unclear in the question

enter image description here

Upvotes: 0

Views: 874

Answers (1)

alf mail
alf mail

Reputation: 1

The code will require some refactoring but if you want to update records in salesforce in bulk, the best approach is to use the Bulk APIs v2

Take a look at salesforce:upsert connector: https://docs.mulesoft.com/salesforce-connector/10.12/salesforce-connector-reference#upsert

Upvotes: 0

Related Questions