SalesforceBulkWriter

SalesforceBulkWriter 64x64

Short description

Ports

Metadata

SalesforceBulkWriter attributes

Details

Examples

Compatibility

See also

Short description

SalesforceBulkWriter writes, updates, or deletes records in Salesforce using Bulk API.

Data output Input ports Output ports Transformation Transf. req. Java CTL Auto-propagated metadata

database

1

2

Ports

Port type Number Required Description Metadata

Input

0

For data records to be inserted, updated, or deleted

input0

Output

0

For accepted data records

input0 plus ObjectId field

Output

1

For rejected data records

input0 plus Error message field

If you do not map an error port and an error occurs, the component fails.

Metadata

SalesforceBulkWriter propagates metadata from left to right.

The metadata on the right side on the first output port have an additional field ObjectId. If the operation is Upsert, the output metadata on the first output port also have an additional field Created.

The metadata on the right side on the second output port have and additional field Error.

Metadata cannot use Autofilling functions.

SalesforceBulkWriter attributes

Attribute Req Description Possible values

Basic

Connection

yes

A Salesforce connection. See Salesforce connections.

e.g. MySFConnection

Salesforce object

yes

An object affected by operation

e.g. Account

Operation

An operation performed on the Salesforce object

insert (default) | update | upsert | delete | hardDelete

Input mapping

Mapping of fields to be inserted/updated/deleted in Salesforce

Unmapped mandatory output fields have an exclamation mark icon.

Map by name (default)

Output mapping

Mapping of successfully inserted/updated/deleted fields

Map by name (default)

Error mapping

Mapping of records that were not inserted/updated/deleted

Map by name (default)

Advanced

Result polling interval (seconds)

Time between queries for results of the batch processing.

The default value is taken from the connection configuration.

5 (default)

Upsert external ID field

(yes)

A field of object specified in Salesforce object which will be used to match records in the Upsert operation. Mandatory for the Upsert operation. Not used in any other operation.

e.g. Id

Job concurrency mode

If SalesforceBulkWriter uses the parallel mode, all batches in the job run at once. Using the parallel mode improves speed of processing and lowers needed API requests (less polling requests for a job status), but it can introduce lots of lock contention on Salesforce objects.

See documentation on parallel and serial modes: General Guidelines for Data Loads

parallel (default) | serial

Batch size

Size of the batch. The default value is 10,000 records.

e.g. 10000

Details

Supported Operations

Insert - inserts new records

Update - updates existing records

Upsert - inserts or updates records

Delete - moves records to recycle bin.

HardDelete - removes records permanently. The operation requires a special permission.

According to the operation you have chosen, different output metadata in Input mapping is displayed in the transform editor.

Bulk API does asynchronous calls. Therefore data records written to Salesforce may appear in the Salesforce web GUI after several seconds or even minutes.

SOAP or Bulk API

If you write more than 1,500-2,000 records, it is better to use Bulk API because it will use less API requests.

Mapping Dialogs

Mapping dialogs uses SOAP API to extract metadata fields on the Salesforce-side of the dialog.

Names of Objects and fields

When specifying Salesforce objects and fields, always use the API Name of the element.

Notes and limitations

SalesforceBulkWriter does not support writing attachments.

Details on API Calls

SalesforceBulkWriter automatically groups records to batches and uploads them to Salesforce. Batch size limit is 10,000 records or 10MB of data. The limit is introduced by the Salesforce Bulk API.

SalesforceBulkWriter uses multiple API calls during its run. All of them count towards your Salesforce API request limit. The precise call flow is:

  1. Login

  2. Extract fields of object specified in the Salesforce object attribute.

  3. Create a bulk job.

  4. Upload batches. The number of calls is the same as the number of batches.

  5. Close the bulk job.

  6. Get job completion status. This call is repeated in an interval specified by the Result polling interval attribute until the job is completed.

  7. Download batch results. The number of calls is the same as the number of batches.

Examples

Insert records into Salesforce

Updating records

Upserting records

Deleting records

Hard-deleting records

Insert records into Salesforce

This example shows a basic use case with insertion of records.

Insert records with new products into Salesforce. Input data fields have the same field names as Salesforce data fields.

Solution

Connect input port of SalesforceBulkWriter with data source.

Create a Salesforce connection.

In SalesforceBulkWriter, fill in Connection and Object.

Attribute Value

Connection

Connection from the second step

Object

Product2

You do not have to specify the operation, as insert is the default one. You do not have to specify Input mapping, as metadata field names are the same as Salesforce field names and the default mapping (by name) is used.

You can attach an edge to the first output port to obtain object IDs of inserted records. You can attach an edge to the second output port to obtain records that have not been inserted.

Updating records

This example shows updating of Salesforce objects.

We do not sell products from our 'PaddleSteamer' family anymore. Set IsActive to false for all products of this family.

Solution

In this example, we have to read IDs of the objects to be updated first (with SalesforceBulkReader). Secondly, set IsActive to false. Finally, update the records in Salesforce (with SalesforceBulkWriter).

Create a Salesforce connection. In SalesforceBulkReader, set Connection, SOQL query and Output mapping.

Attribute Value

Connection

Connection from the first step

SOQL query

SELECT Id FROM Product2 WHERE Family = 'PaddleSteamer'

Output mapping

See the code below

//#CTL2

function integer transform() {
 	$out.0.Id = $in.0.Id;
 	$out.0.IsActive = false;

 	return ALL;
}

In SalesforceBulkWriter, set Connection, Salesforce object, and Operation.

Attribute Value

Connection

Connection from the first step

Salesforce object

Product2

Operation

Update

In SalesforceBulkWriter, no output mapping is specified as mapping by field names is used.

Upserting records

This example shows usage of Upsert operation.

There is a list of companies and their web sites. Update the websites in Salesforce.

Solution

Read records with the company name and object ID from Account object. Match the companies with their websites. Write only the new records or records that have been updated.

Create a Salesforce connection.

In SalesforceBulkWriter, use the Connection, Salesforce ObjectOperation, Output mapping and Upsert external ID field attributes.

Attribute Value

Connection

Connection from the first step

Salesforce object

Account

Operation

Upsert

Input Mapping

See the code below

Upsert external ID field

Id

//#CTL2

function integer transform() {
 	$out.0.Id = $in.0.Id;

 	return ALL;
}

The records containing valid record ID are updated; the records with ID set to null are inserted.

Deleting records

This example shows deleting records.

The product called 'abc' has been inserted multiple times. Furthermore, we do not have 'abc' product anymore. Remove the 'abc' product.

Solution

Create a Salesforce connection.

Read object IDs of 'abc' product with SalesforceBulkReader.

In SalesforceBulkWriter, set Connection, Salesforce object and Operation.

Attribute Value

Connection

Connection from the first step

Salesforce object

Product2

Operation

Delete

Hard-Deleting records

This example shows usage of Hard Delete.

Permanently delete records of specified IDs from Account object. The IDs are received from an input edge.

Solution

Create a Salesforce connection.

In SalesforceBulkWriter, set Connection, Salesforce object, Operation and Input mapping.

Attribute Value

Connection

Connection from the first step

Salesforce object

Account

Operation

Hard Delete

Input mapping

See the code below.

//#CTL2

function integer transform() {
 	$out.0.Id = $in.0.Id;

 	return ALL;
}

The user has to have Bulk API Hard Delete privilege to use the Hard Delete operation.

Compatibility

Version Compatibility Notice

4.3.0-M2

SalesforceBulkWriter is available since 4.3.0-M2. It uses Salesforce Bulk API version 37.0.

4.5.0-M2

SalesforceBulkWriter uses Salesforce Bulk API version 39.0.

4.5.0

You can now set job concurrency mode and batch size.

5.2.0

SalesforceBulkWriter uses Salesforce Bulk API version 45.0.

5.3.0

SalesforceBulkWriter uses Salesforce Bulk API version 46.1.

5.16.0

SalesforceBulkWriter uses Salesforce Bulk API version 55.2.