Integration Platform Technologies: Siebel Enterprise Application Integration > EAI Siebel Adapter Business Service > EAI Siebel Adapter Business Service Methods >

Upsert Method

The Upsert method is similar to the Synchronize method with one exception; the Upsert method does not delete any records.

The Upsert method will result in insert or update operations. If the record exists, it will be updated. If the record does not exist, it will be inserted. Unlike the Synchronize method, upsert will not delete any children.

To determine if an update or insert is performed, the EAI Siebel Adapter runs a query using user keys fields or the search specifications to determine if the parent or primary record already exists. If the parent record exists, it will be updated. If no matching parent record is found, the new record will be inserted. Once again, upsert will not delete any children. If existing children are found, they are updated.

You can update multiple corresponding top-level parent business component records using one XML file, as in the following example:

<SiebelMessage MessageId="" MessageType="Integration Object" IntObjectName="Transaction">

  <ListofTransaction>

<Transaction>

<Field1>xxxx</Field1>

<Field2>yyyy</Field2>

...

</Transaction>

<Transaction>

<Field1>aaaa</Field1>

<Field2>bbbb</Field2>

...

</Transaction>

...

  </ListofTransaction>

</SiebelMessage>