Salesforce Bulk v2 Data Loader

Bulk API v2.0 provides a simple interface to quickly load large amount of the organization's data into the Salesforce system, and bulk query the information using the APIs provided in the connector.

API Versions: 51

API Types: REST

Authentication and Authorization: Default authorization and OAuth 2.0

Key Capabilities: Custom Fields support

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 Salesforce objects and the Salesforce 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

  • createAndUploadDataUsingMultipart: Creates a new job and uploads CSV data that you provide (for data sets with 100,000 characters or less).

  • createAndUploadJobData: Creates a new job and uploads CSV data that you provide (up to 150 MB).

  • getSuccessfulRecord: Lists all successfully processed records for a completed job.

  • getUnprocessedRecord: Lists unprocessed records for a completed job.

  • createQueryJob: Creates a Query job.

  • listJobs: Lists all jobs created in the organization.

  • getJobInfo: Retrieves detailed information about a job.

  • getAllQueryJobsInfo: Retrieves information about all Query jobs.

  • createJob: Creates a job for the Insert, Update, Upsert, Delete, and HardDelete operations.

  • uploadJobData: Uploads the CSV data you provide to run the job.

  • deleteJob: Deletes a job.

  • getQueryJobResult: Returns the result of a Query job.

  • AbortQueryJob: Ends a Query job.

  • closeOrAbortJob: Closes or ends a job.

  • getFailedRecord: Lists failed records for a completed job.

  • createAndUploadDataUsingMultipart: Creates a new job and uploads the CSV data you provide (up to 100,000 characters).

  • createAndUploadJobData: Creates a new job and uploads the CSV data you provide (up to 150 MB).

  • deleteQueryJob: Deletes a Query job.

  • getQueryJobInfo: Retrieves information about the Query job.

Custom Actions

The Salesforce Bulk v2 Data Loader connector allows you to create your own custom actions for performing specific tasks.

Learn more about how to create custom actions.