โ02-02-2021 03:05 PM
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.
โ02-02-2021 03:29 PM
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.
โ02-02-2021 09:20 PM
Hi Manuel! Did you run on test or start mode?
โ02-02-2021 09:29 PM
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.
โ02-02-2021 09:30 PM
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!