topic Re: Salesforce Bulk Update in Workato Pros Discussion Board

Salesforce Bulk Update

mroldanvega — Tue, 02 Feb 2021 23:05:06 GMT

Hey,

Has anyone successfully used the Salesforce Connector Bulk actions to udpate a large (60k+) number of records?

We set up a recipe and then waited for 12 hours and nothing happened. I am opening a Support ticket, but I was curious if anyone had any experience with the Bulk Actions.

Re: Salesforce Bulk Update

mike-flynn1 — Tue, 02 Feb 2021 23:29:23 GMT

Do you see the bulk job when you log into Salesforce? I have had jobs that seem to "stall" in Salesforce when doing large updates.

During data migrations or mergers we using bulk actions to update millions of rows, but typically those updates are broken down into jobs smaller than 60k. The type of update you are doing (object, number of fields being updated, salesforce actions that are triggered based on the updates) and your api/bulk limits in Salesforce help us define the size of each bulk request. I would say our sweet spot for size of bulk operations is typically 10k-20k, and when doing millions of rows of updates all of our requests are asynchronous and we don't wait for responses (we use other methods for determining which records were not updated successfully). For smaller bulk jobs we do the synchronous calls in Workato to process the failed rows.

Re: Salesforce Bulk Update

rak-9177 — Wed, 03 Feb 2021 05:20:31 GMT

Hi Manuel! Did you run on test or start mode?

Re: Salesforce Bulk Update

rak-9177 — Wed, 03 Feb 2021 05:29:53 GMT

We can across this kind of situation when recipe is in test mode and SFDC Bulk actions worked properly on start mode. Behind the scenes, workato sfdc connector will look for sfdc job result every 5mins and will respond accordingly.

Re: Salesforce Bulk Update

mroldanvega — Wed, 03 Feb 2021 05:30:26 GMT

We were running on Test mode, since we needed to run only once.
I got an update from Support that it needs to ve active in order to run.

Thanks a lot!