Bookshelf Home | Contents | Index | PDF |
Oracle Web Services On Demand Guide > Web Services On Demand API Calls > Web Services v2.0 API Calls > ExecuteExecutes multiple insert, delete, or update operations on separate records within a single Web services request. UsageYou use the Execute method to perform different operations on records within the same Web services request for a single object. The operations are defined by the operation attribute on the object element in the SOAP request, for example: specifies an insert operation for an account object. The operation attribute can have one of the following values:
Every object specified in the call requires one valid operation. Mixed node operations are allowed for the Execute method. ArgumentsTable 32 describes the arguments taken by the Execute method.
Return Value of the CallThe status key for each of the Oracle CRM On Demand objects. Sample SOAP Request - ExecuteThe following SOAP request performs Execute operations for four separate contact records in a single Web service request. The first operation inserts a record, the second updates, the third deletes, and the final operation ignores the parent contact record and performs an update on the activity child record. The ContactFirstName and ContactLastName is specified as the user key to identify the contact records in the request. See User Key Fields on the Contact Object for a list of valid user key field combinations for the contact object. NOTE: For operations delete or update, if there are multiple records in Oracle CRM On Demand with the same ContactFirstName and ContactLastName, the request fails with a multiple match error. It is recommended to use the ID user key field to uniquely identify records as it avoids multiple match errors and also improves performance. <?xml version="1.0" encoding="utf-8" standalone="no"?> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <wsse:Username>%%USERNAME%%</wsse:Username> <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">%%PASSWORD%%</wsse:Password> <ContactExecute_Input xmlns="urn:crmondemand/ws/ecbs/contact/"> <ContactFirstName>NewCon5</ContactFirstName> <ContactLastName>NewCon5</ContactLastName> <ContactFirstName>Nathan</ContactFirstName> <ContactLastName>Lak</ContactLastName> <ContactEmail>n@l.com</ContactEmail> <ContactFirstName>NewCon5</ContactFirstName> <ContactLastName>Con5</ContactLastName> <Contact operation="skipnode"> <ContactFirstName>NewCon6</ContactFirstName> <ContactLastName>NewCon6</ContactLastName> Sample SOAP ResponseThe following SOAP response contains the returned status keys for the contact objects: <?xml version="1.0" encoding="utf-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ns:ContactExecute_Output xmlns:ns="urn:crmondemand/ws/ecbs/contact/"> <ListOfContact xmlns="urn:/crmondemand/xml/Contact/Data"> <ModifiedDate>2011-08-25T15:28:34Z</ModifiedDate> <CreatedDate>2011-08-25T15:28:34Z</CreatedDate> <ModifiedById>HRZ780-I5RUE</ModifiedById> <CreatedById>HRZ780-I5RUE</CreatedById> <CreatedBy>Joanne Brown, 08/25/2011 10:28:34</CreatedBy> <ModifiedBy>Joanne Brown, 08/25/2011 10:28:34</ModifiedBy> <ModifiedDate>2011-08-25T15:28:36Z</ModifiedDate> <CreatedDate>2011-08-04T17:01:41Z</CreatedDate> <ModifiedById>HRZ780-I5RUE</ModifiedById> <CreatedById>HRZ780-I5RUE</CreatedById> <CreatedBy>Joanne Brown, 08/04/2011 12:01:41</CreatedBy> <ModifiedBy>Joanne Brown, 08/25/2011 10:28:36</ModifiedBy> <ModifiedDate>2011-08-12T15:11:17Z</ModifiedDate> <CreatedDate>2011-08-12T15:11:17Z</CreatedDate> <ModifiedById>HRZ780-I5RUE</ModifiedById> <CreatedById>HRZ780-I5RUE</CreatedById> <CreatedBy>Joanne Brown, 08/12/2011 10:11:17</CreatedBy> |
Oracle Web Services On Demand Guide, Version 26.0 (Oracle CRM On Demand Release 38) | Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |