Salesforce Update REST API Throughput

[tarena]

The Salesforce REST API can update up to 200 records be POST call. The Salesforce Update snap documentation says that it's implemented to only update 1 record at a time in REST mode. The Bulk API is asynchronous, even in serial mode. 

What is the best practice in SnapLogic to maximize throughput of synchronous record updates to Salesforce.

I could implement the Salesforce REST API through the HTTP Client, but then what is the point of the Salesforce Snap Pack?

[tarena · Accepted solution]

After some more experimentation, the Salesforce Poller snap keeps the pipeline open for the entire duration of the update and return individual successes and failure for each record. This is close enough to synchronous for my use cases.

[smudassir]

@tarena , the update snap should support rest and bulk apis (available via dropdown).  Can you try using bulk api instead?  Also, I believe we have salesforce bulk update snap too that can be leveraged here.  FYI

[tarena]

Part of my use case is that I need to ensure that all records are processed before I close the pipeline. The Bulk API is asynchronous and closes the snap when all the batches have been created, but before they are completely processed. The results of the record-level updates aren't available from the Bulk Snap or the Update snap using the Bulk API.

The Salesforce Poller keeps the pipeline open until all the record updates are complete and returns record-level success/failure.