Not available in Community Designer

Connect input port of SalesforceBulkWriter with data source.

Create a Salesforce connection.

In SalesforceBulkWriter, fill in Connection and Object.

We do not have to specify the operation, as insert is the default one. We 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.

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.

//#CTL2

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

 	return ALL;
}

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

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

Read records with 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 attributes Connection, Salesforce Object Operation, Output mapping, and Upsert external ID field.

//#CTL2

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

 	return ALL;
}

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

Create a Salesforce connection.

Read object IDs of 'abc' product with SalesforceBulkReader.

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

Create a salesforce connection.

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

//#CTL2

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

 	return ALL;
}

	Note
	The user has to have Bulk API Hard Delete privilege to use Hard Delete operation. See https://help.salesforce.com/apex/HTViewSolution?id=000171306&language=en_US.