About Exporting Data for Lists of Values

Third-party applications use the SWILSClinicalListOfValues Web service 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 14-1 lists the XML queries that the SWILSClinicalListOfValues Web service supports for exporting list of value records to a third-party application.

Table 14-1 XML Queries that SWILSClinicalListOfValues Supports 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.

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.