Bookshelf Home | Contents | Index | PDF |
Oracle Web Services On Demand Guide > Web Services On Demand API Calls > Service API Calls > AuditTrailQueryPageReturns records from the master audit trail. UsageYou use the AuditTrailQueryPage method to execute a query against the master audit trail, and return a subset of the records that match the search criteria set by the method arguments. The following are attributes of the <ListOfAuditTrail> element that you can specify:
You can also use the searchspec attribute on the AuditTrail element to provide a search specification. Each of the child elements of <ListOfAuditTrail> can have the following attributes:
The following are attributes of the <AuditTrailData> element that can be returned:
ArgumentsTable 41 describes the arguments taken by the AuditTrailQueryPage method.
Return Value of the CallThe following information is returned:
There are also various elements with names beginning with Created, Modified, and Updated that give information about who performed the create, modify, or update operation on the record. Sample SOAP Request - AuditTrailQueryPageThe following SOAP request queries the audit trail. It demonstrates the use of the pagesize and startrownum attributes to return a specific number of records starting at a specific row. The searchspec attribute species that only records modified after a certain date and time are to be returned: <?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> <AuditTrailQueryPage_Input xmlns="urn:crmondemand/ws/audittrail/"> <ListOfAuditTrail startrownum="0" pagesize="100" recordcountneeded="true"> <AuditTrail searchspec="[ModifiedDate] > '2013-06-02T07:52:59Z'"> Sample SOAP ResponseThe following illustrates the SOAP response (most of the <AuditTrail> elements are omitted, as indicated by the ellipses (...)): <?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:AuditTrailQueryPage_Output> <ListOfAuditTrail recordcount="24" lastpage="true"> <ModifiedDate>2014-06-02T07:52:59Z</ModifiedDate> <CreatedDate>2014-06-02T07:52:59Z</CreatedDate> <ModifiedById>1-D5S9Z</ModifiedById> <CreatedById>1-D5S9Z</CreatedById> <RecordType>Opportunity</RecordType> <RecordUpdatedDate>2014-06-02T07:52:58Z</RecordUpdatedDate> <UserFirstName>System</UserFirstName> <UserFullName>SystemAdmin</UserFullName> <UserLastName>Admin</UserLastName> <UserSignInId>ADMIN@CUSTCOMP2.COM</UserSignInId> <FieldName>Sales Stage - Translation</FieldName> <RecordName>Testing</RecordName> <SourceIPAddress>12.168.23.232</SourceIPAddress> <UpdatedByFirstName>System</UpdatedByFirstName> <UpdatedByLastName>Admin</UpdatedByLastName> <UpdatedByUserSignInId>ADMIN@CUSTCOMP2.COM</UpdatedByUserSignInId> <UpdatedByAlias>System Admin Alias (admin@custcomp2.com)</UpdatedByAlias> <UpdatedByFullName>System Admin</UpdatedByFullName> <UpdatedByIntegrationId>1-D5S9W</UpdatedByIntegrationId> <UpdatedByEMailAddr>wiley.coyote@acme.com</UpdatedByEMailAddr> <CreatedByFirstName>System</CreatedByFirstName> <CreatedByLastName>Admin</CreatedByLastName> <CreatedByUserSignInId>ADMIN@CUSTCOMP2.COM</CreatedByUserSignInId> <CreatedByAlias>System Admin Alias (admin@custcomp2.com)</CreatedByAlias> <CreatedByFullName>System Admin</CreatedByFullName> <CreatedByIntegrationId>1-D5S9W</CreatedByIntegrationId> <CreatedByEMailAddr>wiley.coyote@acme.com</CreatedByEMailAddr> <CreatedBy>System Admin, 06/02/2014 07:52:59</CreatedBy> <ModifiedBy>System Admin, 06/02/2014 07:52:59</ModifiedBy> <NewFieldValue>Short List</NewFieldValue> <OldFieldValue>Qualified Lead</OldFieldValue> <ModifiedDate>2014-06-02T08:06:10Z</ModifiedDate> <CreatedDate>2014-06-02T08:06:10Z</CreatedDate> <ModifiedById>1-D5S9Z</ModifiedById> <CreatedById>1-D5S9Z</CreatedById> <RecordUpdatedDate>2014-06-02T08:06:10Z</RecordUpdatedDate> <UserFirstName>System</UserFirstName> <UserFullName>System Admin</UserFullName> <UserLastName>Admin</UserLastName> <UserSignInId>ADMIN@CUSTCOMP2.COM</UserSignInId> <FieldName>Account/Audit Trail Item 2</FieldName> <RecordName>Administrator Owner Access Profile</RecordName> <SourceIPAddress>12.168.23.232</SourceIPAddress> <UpdatedByFirstName>System</UpdatedByFirstName> <UpdatedByLastName>Admin</UpdatedByLastName> <UpdatedByUserSignInId>ADMIN@CUSTCOMP2.COM</UpdatedByUserSignInId> <UpdatedByAlias>System Admin Alias (admin@custcomp2.com)</UpdatedByAlias> <UpdatedByFullName>System Admin</UpdatedByFullName> <UpdatedByIntegrationId>1-D5S9W</UpdatedByIntegrationId> <UpdatedByEMailAddr>wiley.coyote@acme.com</UpdatedByEMailAddr> <CreatedByFirstName>System</CreatedByFirstName> <CreatedByLastName>Admin</CreatedByLastName> <CreatedByUserSignInId>ADMIN@CUSTCOMP2.COM</CreatedByUserSignInId> <CreatedByAlias>System Admin Alias (admin@custcomp2.com)</CreatedByAlias> <CreatedByFullName>System Admin</CreatedByFullName> <CreatedByIntegrationId>1-D5S9W</CreatedByIntegrationId> <CreatedByEMailAddr>wiley.coyote@acme.com</CreatedByEMailAddr> <CreatedBy>System Admin, 06/02/2014 08:06:10</CreatedBy> <ModifiedBy>System Admin, 06/02/2014 08:06:10</ModifiedBy> <NewFieldValue>1</NewFieldValue> <OldFieldValue>-1</OldFieldValue> |
Oracle Web Services On Demand Guide, Version 21.0 (Oracle CRM On Demand Release 33) | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |