Delete

Delete

Finds records in the Oracle CRM On Demand database that match specified field values, and then deletes them. Deleted records are visible in the Deleted Items area of the Oracle CRM On Demand UI and can be queried using the DeletedItemQueryPage method.

DeleteChild

Not applicable

Deletes child records from the Oracle CRM On Demand database, or removes the association between the child and the parent object.

Not applicable

Execute

Executes multiple update, insert, and delete operations on separate records in the Oracle CRM On Demand database within the same Web services request.

Insert

Insert

Inserts new records into the Oracle CRM On Demand database.

InsertChild

Not applicable

Inserts new child records into the Oracle CRM On Demand database.

InsertOrUpdate

Not applicable

Updates existing records or inserts a new record if one did not exist.

QueryPage

QueryPage

Executes a query against a specified list of records, and returns a subset of the records that match the search criteria set by the method arguments.

Update

Update

Updates records with a new value.

UpdateChild

Not applicable

Updates child records with a new value.

Supports an upsert operation through InsertOrUpdate call

Does not support an upsert operation

Pagination parameters are supported only at the parent level

Pagination parameters are supported at both the parent and child level

Returns all child records even if the condition is true for one child.

For example, the QueryPage call returns all partner children from an account even if the condition is true for only one partner child

Outputs only the specific child whose condition was met.

For example, QueryPage returns only the specific partner child from the account for which the condition was true.

UseChildAnd argument of QueryPage call is available for using OR/AND logic between parent and child

The UseChildAnd argument is not available.

Instead, by default, all parent records matching the parent criteria and only children matching the child criteria are returned.

Operators cannot be used to construct complex queries across multiple fields

The SearchSpec argument of QueryPage can be used to construct complex queries across multiple fields in a request. For example, the OR operator can be used to find all records that match the specified condition for [Field A] OR the specified condition for [Field B].

Sort order is not customizable

Sortorder and sortsequence arguments are available to customize the sorting order of the records

Update call removes child objects not specified in the request

An Execute call with "operation=update" at the parent level removes the unspecified children in the request

InsertChild call is used to insert the children for existing parent objects

For Web Services v2.0:

• Insert call can be used to insert both parent records and child records.
• If a child node is specified in the request, the Insert call inserts the child and associates it with the existing parent record.
• If a child node is missing, the Insert call inserts only the new parent record.

UpdateChild call is used to update child records

For Web Services v2.0:

• Update call can be used to update parent records and child records
• If a child node is specified in the request, the Update call updates the child in the existing parent record
• If the child node is missing, the Insert call updates only the existing parent record

DeleteChild call is used to delete the child records

For Web Services v2.0:

• Delete call can be used to delete both parent records and child records
• If the child node specified in the request is available, the Delete call deletes the child in the existing parent record, and leaves the parent record undeleted.
• If the child node is missing, the Delete call deletes the existing parent record.

InsertChild, UpdateChild, and DeleteChild methods are used to perform operations on child records

In an Execute request, a specific node within the request can be skipped using the "operation=skipnode" attribute.

This can be used to simulate InsertChild, UpdateChild or DeleteChild by skipping the parent node and only performing the specified actions on the child records.

LOVLanguageMode argument is not available

The LOVLanguageMode argument is an input argument for all of the Web Services v2.0 calls. It determines whether the processing for picklist fields occurs using language independent codes (LIC) or language dependent codes (LDC).

ViewMode argument is not available

The ViewMode argument, which specifies the level of access to records specified in the method call, is available for all of the Web Services v2.0 calls.

Does not support access to custom Web applets.

Supports access to custom Web applets as read-only child objects of a parent object.