Salesforce Bulk Data Loader

The Salesforce Bulk Data Loader connector provides support for Job and Batch resources. You can create, update, delete, query jobs and batches, as well as operate on large amounts of records asynchronously using batches, which are processed by Salesforce 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.
  • Salesforce account 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