Salesforce Bulk Data Loader

The Salesforce Bulk Data Loader connector supports Job and Batch resources, allowing you to create, update, delete, and query jobs and batches. It enables asynchronous processing of bulk records in batches, which Salesforce processes in the background.

API Versions - 44, 48, 51, 53

API Types - REST

Authentication and Authorization - Credentials, OAuth 2.0, JWT

Key Capabilities - Custom Fields Support, $filter

Prerequisites -
  • Salesforce web service login and password information.
  • The Salesforce account that you are using has privileges to connect to the Salesforce API. If you are unsure of your privileges, your Salesforce representative can provide you with a Sender ID and password specific to the Salesforce API.
  • You are familiar with the Salesforce objects and APIs. For this, do the following -
    1. Create a Connected App in Salesforce.
    2. Generate an Access and Refresh token using the REST client.

Actions

  • abortOrCloseAJob: Ends or closes a job

  • getAllBatchDetails: Returns the batch list for the specified jobID

  • getBatchDetails: Returns high-level batch details for the specified batchID

  • getBatchRequest: Returns the batch request details

  • getJobDetails: Returns the job details

  • retrieveQueryBatchResult: Returns the results of a batch query for the specified batch and job identifiers

  • submitDeleteBatch: Submit multiple deletes of business objects as a batch

  • submitInsertBatch: Submits multiple insert requests of business objects as a batch

  • submitQueryBatch: Submits a batch of Salesforce queries for processing

  • submitUpdateBatch: Submits multiple update requests of business objects as a batch