Bulk Upsert Records

Operation name

Bulk Upsert Records

Function overview

Inserts records all at once when the records don't exist in an object, or updates records all at once when the records exist in an object using Salesforce Bulk API 2.0.

This component uses "upsert" for REST API.

To check technical details, go to salesforce.com and check the page for SOQL queries and other related pages in the REST API Developer Guide.

Data model

The data model of this component is table model type.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter a name that is used on the script canvas.

Required settings

Item name	Required/Optional	Use of variables	Description
Authentication settings	Required	Not available	Select a connection resource (OAuth) to use for authentication. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.
Connection settings	Required	Not available	Select a connection resource. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.
Object name	Required	Available	Enter an object name.
Field list	Required	-	Specify fields.
Field list/Target	-	Not available	Select whether or not to include each field in target to write. Selected Include in the target to write. Not selected (Default) Don't include in the target to write.
Field list/Label	-	Not available	The field label is displayed.
Field list/Name	-	Not available	The field name (system name) is displayed.
Field list/Type	-	Not available	The name of the type in Salesforce is displayed.
Field list/Inner type	-	Not available	The inner type for HULFT Square is displayed.
External ID field	Required	Not available	Select a field to use as the external ID.

Property actions

Item name	Description	Remarks
Refresh object name list	Object name is retrieved and the list is updated.
Refresh field list	The field list of the object that is set is retrieved and updated.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Schemas

Input schema

Element name	Column name	Description
row	-	Repeats for the number of the entities.
column	Value for the external ID field	Enter the value for External ID field.
Value of the target field that is selected in Target of Field list	Enter the values for the target fields that are selected in Target of Field list.

Element name

Column name

Description

Remarks

row

Repeats for the number of the entities.

column

Value for the external ID field

Enter the value for External ID field.

Value of the target field that is selected in Target of Field list

Enter the values for the target fields that are selected in Target of Field list.

Output schema

<?xml version="1.0" encoding="UTF-8" ?>
<table>
  <row>
    <column>success</column>
    <column>created</column>
    <column>error_message</column>
    <column>Value of the target field</column>
  </row>
  <row>
    :
  </row>
</table>

Element name	Column name	Description	Remarks
row	-	Repeats for the number of entities to be inserted or updated.
column	success	The result of record update is output.	true Record update succeeded. false Record update failed (error).
	created	The result of record insertion is output.	true Record insertion succeeded. false Record insertion failed (error). When success is true and created is false, the records were updated successfully.
	error_message	The message returned by Salesforce when an error occurs is output.
	Value of the target field	The value of the target field that is selected in Target of Field list is output.

Loading schema in Mapper

The schema is loaded automatically.

Specify the schema of the data to be loaded.

= Remarks =

For details, refer to Edit Schema.

Mass data processing

Mass data processing is supported.

Parallel Stream Processing

PSP is supported.

= Remarks =

For details on PSP, refer to Parallel Stream Processing.

Available component variables

Component variable name	Description	Remarks
count	The number of records that were inserted and updated successfully is stored.	The default value is null.
insert_count	The number of records that were inserted successfully is stored.	The default value is null.
update_count	The number of records that were updated successfully is stored.	The default value is null.
error_count	The number of records that failed to be inserted and updated is stored.	The default value is null.
message_category	When an error occurs, the category of the message code corresponding to the error is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error is stored.	The default value is null.
error_type	When an error occurs, the error type is stored.	The default value is null. The format of the error type is as follows. Example: java.io.FileNotFoundException
error_message	When an error occurs, the error message is stored.	The default value is null.
error_trace	When an error occurs, the trace information for the error is stored.	The default value is null.

Message codes, exception messages, and limitations

Connector	Message code	Exception message	Limitations
Messages and limitations of the Salesforce connector			None