Salesforce Bulk

Provides bulk functionality for Salesforce.

Revision History

1.1.0.0 Breaking update: added OAuth authentication.

1.1.0.1 Added legacy properties.

1.1.0.2 Fixed lock not being released.

1.1.1.0 Fixed samples not being generated.

See Upgrading Nodes for instructions on how to safely upgrade connections.

Properties

Operation

Type: List Input
InitiateIngestJob - Starts a new Bulk API ingest job in Salesforce for inserting, updating, upserting, or deleting records
GetIngestJobStatus - Retrieves the current status of a previously initiated ingest job
GetIngestJobSuccessResults - Returns the list of records that were successfully processed in the ingest job
GetIngestJobFailedResults - Returns the list of records that failed during processing, typically with error messages explaining why
GetIngestJobUnprocessRecords - Retrieves records that were not processed at all, often due to job interruption or format issues

IngestAction

Type: List Input
Insert - Inserts one or more records
Update - Updates one or more records keyed on the Id field
Upsert - Updates or Creates one or more records. If Id or the field name specified in ExternalIdField is present, an update is performed otherwise a create is performed
The Action to perform against the object in ObjectName
Delete - Deletes the records specified in Request

ObjectName

Type: String Input
The name of the object to be acted upon

ExternalIdField

Type: String Input
Where Action is Update or Upsert , records can be updated by keying them on the Id field or, if a value is provided for ExternalIdField , by keying them on that field instead.

RowDelimiter

Type: List Input
CRLF - Carriage Return followed by Line Feed (\r\n)
LF - Line Feed (\n)

ColumnDelimiter

Type: List Input
COMMA - A comma (,). This is the most common delimiter for CSV files
SEMICOLON - A semicolon (;). Useful when your data fields contain commas and you want to avoid quoting
TAB - A tab character (\t). Often used in TSV (Tab-Separated Values) files and helpful when fields may contain both commas and semicolons

Encapsulator

Type: String Input
Provides a string that will be used to encapsulate values (cells) in the flat file.

FlatFileDocument

Type: Multiline Text InputOuput
Provides access to the flat file document being parsed or emitted.

JobId

Type: String Input
This field is required for all Operations that Query or Interact with the same job—such as GetIngestJobStatus , GetIngestJobSuccessResults , GetIngestJobFailedResults , or GetIngestJobUnprocessRecords .
Use this field to reference the specific job whose status or results you wish to retrieve.

Response

Type: Xml Output
The response returned by the Salesforce API

Remarks

Use this Node in conjunction with the primary Salesforce Node.

Creating a Connection

Refer to the Salesforce Node remarks for details on how to configure a Connection.

See Also

Salesforce