InsertOrUpdate

Updates existing records or inserts a new record if one did not exist for an instance of the object.

Usage

You use the InsertOrUpdate method to update one or more records of a particular object in an Oracle CRM On Demand instance. Use the user key specified for the parent level objects in the input argument to determine whether to insert each of the parent records, or to update an existing parent record.

Insert calls must include values for fields that are required for the object. Fields can be conditionally required, that is they become required if the data specified for other fields on the record meets the criteria defined in an expression for the field. For more information about conditionally-required fields, see Oracle CRM On Demand Online Help.

The following table outlines how the InsertOrUpdate method acts on parent and child objects to create or update an object instance.

Table Effect of InsetOrUpdate on Parent and Child Objects

Method New Parent New Child Existing Parent Existing Child Record

InsertOrUpdate

New parent

New child

Update parent

Update child

Arguments

The following table describes the arguments taken by the InsertOrUpdate method.

Table Arguments Taken by the InsertOrUpdate Method

Name Description Required Default I/O

ListOf(Object). For example, ListOfAccount

The object instances to be inserted or updated.

Yes

Not available

Input/Output

Echo

Controls whether data sent to Oracle CRM On Demand through integration Web services are recorded as transactions.

No

On

Input

Return Value of the Call

The status key for each of the inserted or updated objects.

Related Topic

Update, Insert