Salesforce Upsert All
The Salesforce Upsert All activity creates new objects or updates existing objects; uses a custom field to determine the presence of existing objects.
- If the external ID does not match, a new object is created.
- If the external ID is matched once, the existing object is updated.
- If the external ID is matched multiple times, an error is reported.
- When batch updating multiple objects where the external ID is the same for two or more objects in your batch call, those records are marked as errors in UpsertResult. The objects are neither created nor updated.
In the General tab, you can establish a connection to the Salesforce.com server.
The following table lists the configurations in the General tab of the Salesforce Upsert All activity:
In the Description tab, you can enter a short description for the Salesforce Upsert All activity.
In the Input tab, you can specify input values for the Salesforce Upsert All activity.
The following table lists the input elements in the Input tab of the Salesforce Upsert All activity:
In the Output tab, you can find the output value.
The following table lists the output elements in the Output tab of the Salesforce Upsert All activity:
|Output Item||Data Type||Description|
|result||created||Boolean||Indicates whether the record is created (true) or updated (false).|
|errors||Complex||If errors occur during the activity, an array of error objects with the error code and description, is returned.|
|id||String||The ID of an sObject that you attempt to create.|
|success||Boolean||Indicates whether the Salesforce Create All activity has succeeded (true) or not (false).|
In the Fault tab, you can find the error code and error message of the Salesforce Upsert All activity. See TIBCO ActiveMatrix BusinessWorks Error Code for more information about error codes and corrective actions to take.
|SalesforceExecuteSOAPMethodException||An error occurred when calling an SOAP method.
For example, wrong values are set in the Input fields or the Salesforce session has timed out.
|SalesforceLoginException||An error occurred when logging in to the Salesforce.com server.|
|SalesforceConnectionNotFoundException||An error occurred when the external session ID is not used or the Salesforce connection is not configured correctly.|