Use this activity to update existing objects or create
new objects in Saleforce.com.
The activity uses an external ID, usually a foreign key,
to determine whether to update an existing object or create a new
object in Salesforce.com.
While the Salesforce.com API limits
the number of objects that it can create in a single upsert call to
200 objects, the WebSphere® Cast
Iron Salesforce.com connector does not have such a limit. You can
use the Upsert Objects activity to create an unlimited number
of objects.
To use the
Upsert Objects activity:
Procedure
- In the Activities tab, open the Salesforce.com directory
to find the Upsert Objects activity.
- Add the activity to an orchestration. The Checklist and Summary for
the activity are displayed below the orchestration.
- Select a Salesforce.com endpoint. For instructions on creating
or editing a Salesforce.com endpoint, see Creating
or Editing a Salesforce.com Endpoint.
- Configure the
activity, by choosing a Salesforce.com object type and object field
preferences.
Note: You can only choose object types that
the Integration Appliance can update or create and contain at least
one External ID field. When you select the object
type, Studio displays the external IDs defined on the object type
in the External ID field of the Configure pane.
You cannot edit the IDs listed in the External ID list.
The external ID that you select becomes a required field, you cannot
clear this field from the Object Field Preferences table.
If only one external ID is available, Studio automatically selects
this field in the Object Field Preferences table.
- Specify the
Retry and Time out parameters for the activity.
- Map the input of the activity.
- Map the output of the activity.
Map the input of the Upsert Objects activity
- In the Checklist, select Map Inputs.
The objects element is displayed in the To Activity panel.
- Right-click the default node and choose Show
Optional Parameters, to show the optional input parameters
for this activity:
- AssignmentRuleHeader
- MruHeader
- EmailHeader
- CallOptions
- connection
- sessionInfo
- Click Select Inputs... and select the
input variable or variables for the map. For instructions about creating
variables, see Creating variables.
- As appropriate, map the input parameters to the variable or variables.
For mapping instructions, see Creating a map.
This activity supports the following optional input parameters:
- AssignmentRuleHeader
- EmailHeader
- MruHeader
Optional and nillable field
elements have the following behavior:
Map the output of the Upsert Objects activity
- In the Checklist, select Map Outputs.
The upsertResults element is displayed in the From Activity
panel.
- Click Select Outputs... and select the
output variable or variables for the map. For instructions about creating
variables, see Creating variables.
- As appropriate, map the output parameters to the variable or variables.
For mapping instructions, see Creating a map.