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.