Siebel Clinical Trial Management System Guide > Setting Up and Configuring Mobile Integration of Clinical Trip Reports >

About Exporting Data for Lists of Values


The SWILSClinicalListOfValues Web service is used by third-party applications to request list of value (LOV) records from Siebel Clinical Trial Management System.

The following data is exported:

  • Visit types
  • Visit status
  • Trip report status
  • Activity
  • Activity type
  • Status
  • Display in

The third-party application submits the data queries to Siebel Clinical in XML format. Table 13 lists the XML queries supported by the SWILSClinicalListOfValues Web service for exporting list of value records to a third-party application.

Table 13. SWILSClinicalListOfValues XML Queries Supported for Exporting List of Value Records
Third-Party XML Query Example
Description

<asi:LOVQueryByExample_Input>

<list:Type>AAG*</list:Type>

When Siebel Clinical receives a validated value for Type in the Web service request, the Siebel Web service response provides all the LOV records for the specified Type.

<asi:LOVQueryPage_Input>

<asi:PageSize>100</asi:PageSize>

<list:ListOfListOfValues>

<list:ListOfValues>

<list:Id>*</list:Id>

<list:Language>*</list:Language>

<list:LanguageName>*</list:LanguageName>

<list:Modifiabl>*</list:Modifiable>

<list:Multilingual>*</list:Multilingual>

<list:Name>*</list:Name>

<list:ReplicationLevel>*</list:ReplicationLevel>

<list:Translate>*</list:Translate>

<list:Type>AAG*</list:Type>

<list:Value>*</list:Value>

<asi:StartRowNum>50</asi:StartRowNum>

When Siebel Clinical receives a validated value for PageSize and Type in the Web service request, the Siebel Web service response provides the LOV records for the specified type, page size, and starting row. A PageSize value of 100 and StartRowNum value of 50 returns 100 records, starting at row 50.

The page size is a required argument, and cannot be greater than the MaximumPageSize set on the server.

StartRowNum is an optional argument, and the default value is 0.

Siebel Clinical Trial Management System Guide Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.