1. Home
  2. docs
  3. Mule Adapter
  4. 5 How to use bulk api to push high volume data to Salesforce?

5 How to use bulk api to push high volume data to Salesforce?

You can push high volume of data using Skyvva Sfdc bulk operation. Internally it used the salesforce bulk v2 api to complete your request. It will provide a response with bulk job details once the bulk job is completed. You need to configure your Skyvva interface with the Bulk mode enabled to use this feature for your interface.

Mule will list all the integration that you can select to use this operation. Base on your integration then Mule will show all the interface which has been configured to use Bulk. You need to configure both integration and interface in mule for this operation. The salesforce operation (insert/update/upsert/delete) need to be set in the Skyvva interface. You need to configure how to deal with the empty field in your input data based on that configuration the empty field configuration, mule will be ignore the update of that value or will be set the value to null.  You can select the Skyvva Bulk version base as „SFDC Bulk API 2.0“ or „SKYVVA Bulk 1.0“.  The connector will use the correct bulk version base on your selection internally to fulfill your request.

On selection of „SFDC Bulk API 2.0“, it will use the Salesforce Bulk v2  API and it will result the job details as output from the connector. But if you select „SKYVVA Bulk 1.0“ then it will use Skyvva Bulk integration which creates an Attachment object with ParentId as the interface object Id. Then you can track the progress of that using Salesforce Skyvva application.

You can use the „Bulk Control Board“ from your Integration to track the progress of your Bulk integration when you have used SKYVVA Bulk 1.0.

You can schedule a scheduler for your skyvva bulk message or you can manually run manually using Process Bulk Attachment button as shown bellow.

Once the scheduler ran then the status of the bulk can be find in Bulk Data Monitor Section as below:

If the status is  completed, you can find the details of the messages in the Messages section of the Integration.

The below screenshot shows how you can find the message details on Message.

 

The below screen shows how it can be configured in mule for Sfdc bulk operation.

You can use a transform message before this component in Mule to set the input for this operation. The input required for this operation should be in json format. It will automatically shows you the metadata in the required format for your selected skyvaa interface. The below screen show an example of interface that used Account object. The relationship column will automatically shows you the in the required format in the transform message datasense.

The below flow will show an example use of the Skyvva Sfdc bulk operation.

The request and response for the above example flow is as below. If there will be any failure of record the same will be added as skyvva message.

Once you get the bulk result from your request then can find the Bulk job related information from the Salesorces. Go to Setup -> In Quick Find search for Bulk. Click on Bulk Data Load Jobs.

On that page you will able to find your Bulk job details. Click on the Job ID to find more details on your job.

 

 

Was this article helpful to you? Yes No 1

How can we help?