Bookshelf Home | Contents | Index | PDF     

Oracle Web Services On Demand Guide > Web Services On Demand API Calls > Service API Calls >

MetadataChangeSummaryQueryPage

Gets a summary of changes to various categories of metadata.

Usage

You use the MetadataChangeSummaryQueryPage method to determine whether there have been any metadata changes in Oracle CRM On Demand. Only the relevant changes can be extracted and applied to client applications.

With the Administration Services API, field and picklist data, for example, can be accessed and modified (see, for example, FieldManagementUpsert and PicklistUpsert).

Arguments

Table 60 describes the arguments taken by the MetadataChangeSummaryQueryPage method.

Table 60. Arguments Taken by the MetadataChangeSummaryQueryPage Method
Name
Description
Required
Default
I/O

ListOfMetadataChangeSummary

The metadata to be queried and returned.

Yes

Not applicable

Input/Output

recordcountneeded

Indicates whether a record count for the query is to be returned.

No

false

Input

PageSize

The maximum number of records displayed on a page following a query.

No

10

Input

StartRowNum

Indicates the row from which the method starts to return records.

No

0

Input

searchspec

Indicates the search specification.

No

Not applicable

Input

sortsequence

An integer value that determines the order of the sort specification.

No

 

Input

sortorder

Determines the sort order for the records returned by the query, either ASC for ascending or DESC for descending.

No

ASC

Input

LastPage

A value that indicates whether or not the last value in the query set has been returned.

Not applicable

Not applicable

Output

recordcount

An integer value that indicates the record count.

Not applicable

Not applicable

Output

Return Value of the Call

The following information is returned:

  • LOVLastUpdated. The date and time of the last picklist update.
  • CascPicklistsLastUpdated. The date and time of the last cascading picklist update.
  • FieldManagementLastUpdated. The date and time of the last field management data update.
  • WorkflowLastUpdated. The date and time of the last workflow update.
  • AccessProfileLastUpdated. The date and time of the last access profile update.
  • BookOfBusinessLastUpdated. The date and time of the last book update.
  • ThemesLastUpdated. The date and time of the last theme update.

Sample SOAP Request - MetadataChangesSummaryQueryPage

The following SOAP request retrieves the summary of changes to various categories of metadata:

<?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">

   <soap:Header>

      <wsse:Security>

         <wsse:UsernameToken>

            <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>

         </wsse:UsernameToken>

      </wsse:Security>

   </soap:Header>

   <soap:Body>

      <MetadataChangeSummaryQueryPage_Input xmlns="urn:crmondemand/ws/metadatachangesummary/">

         <ListOfMetadataChangeSummary>

            <MetadataChangeSummary>

               <LOVLastUpdated />

               <CascPicklistsLastUpdated />

               <FieldManagementLastUpdated />

               <WorkflowLastUpdated />

               <AccessProfileLastUpdated />

               <BookOfBusinessLastUpdated />

               <ThemesLastUpdated />

            </MetadataChangeSummary>

         </ListOfMetadataChangeSummary>

      </MetadataChangeSummaryQueryPage_Input>

   </soap:Body>

</soap:Envelope>

Sample SOAP Response

The following response contains the returned metadata:

<?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">

   <SOAP-ENV:Body>

      <ns:MetadataChangeSummaryQueryPage_Output xmlns:ns="urn:crmondemand/ws/metadatachangesummary/">

         <ListOfMetadataChangeSummary xmlns="urn:/crmondemand/xml/metadatachangesummary/Data" lastpage="true">

            <MetadataChangeSummary>

               <LOVLastUpdated>2011-08-04T14:46:19</LOVLastUpdated>

               <CascPicklistsLastUpdated>2011-08-04T15:06:08</CascPicklistsLastUpdated>

               <FieldManagementLastUpdated>2011-08-03T11:36:21</FieldManagementLastUpdated>

               <WorkflowLastUpdated>2016-01-29T11:32:09</WorkflowLastUpdated>

               <AccessProfileLastUpdated>2016-12-01T20:25:14</AccessProfileLastUpdated>

               <BookOfBusinessLastUpdated>2016-12-19T11:43:06</BookOfBusinessLastUpdated>

            </MetadataChangeSummary>

         </ListOfMetadataChangeSummary>

      </ns:MetadataChangeSummaryQueryPage_Output>

   </SOAP-ENV:Body>

</SOAP-ENV:Envelope>

    
Oracle Web Services On Demand Guide, Version 25.0 (Oracle CRM On Demand Release 37) Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.