Siebel Clinical Trial Management System Guide > Setting Up and Configuring Site Visit Data Integration >

About Exporting Data for Site Visits


The SWILSClinicalQueryProtocolSite_SiteVisits Web service is used by third-party applications to request site monitor, site, and site visit records from Siebel Clinical. The third-party application submits the data queries to Siebel Clinical in XML format. Table 11 lists the XML queries supported by the SWILSClinicalQueryProtocolSite_SiteVisits Web service for exporting site visit data to a third-party application.

Table 11. SWILSClinicalQueryProtocolSite_SiteVisits XML Queries Supported for Exporting Site Visit Data
Third-Party XML Query
Description
Validation

<ls:UserId>SIAADMIN</ls:UserId>

<ls:ProtocolNumber>*</ls:ProtocolNumber>

When Siebel Clinical receives a validated Siebel User ID in the Web service request, the Siebel Web service response provides the records for the sites, site visits, and protocols which that User ID is associated with.

User ID must be a team member listed in the Assigned To list for the site visit. For more information about the Assigned To list for site visits, see Creating and Managing Site Visits.

<ls:UserId>*</ls:UserId>

<ls:ProtocolNumber>AMXN 9374</ls:ProtocolNumber>

When Siebel Clinical receives a validated Siebel protocol number in the Web service request, the Siebel Web service response provides the records for the sites and site visits which that protocol number is associated with.

Not applicable.

<ls:UserId>SIAADMIN</ls:UserId>

<ls:ProtocolNumber>AMXN 9374</ls:ProtocolNumber>

When Siebel Clinical receives a validated Siebel User ID and protocol number in the Web service request, the Siebel Web service response provides the records for the sites and site visits which that User ID and protocol number are associated with.

User ID must be a team member listed in the Assigned To list for the site visit.

<ls:UserId>*</ls:UserId>

<ls:ProtocolNumber>*</ls:ProtocolNumber>

The Siebel Web service response returns the records for all clinical sites and site visits.

Not applicable.

Example of Configuring SWILSClinicalQueryProtocolSite_SiteVisits Web Service Request

This extract provides an example of configuring the SWILSClinicalQueryProtocolSite_SiteVisits Web service request. It returns all site and site visit records associated with user SIAADMIN. For more information about configuring the SWILSClinicalQueryProtocolSite_SiteVisits Web service, see Siebel CRM Web Services Reference.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:cus="http://siebel.com/CustomUI" xmlns:ls="http://www.siebel.com/xml/LS%20Clinical%20Protocol%20Site_Site%20Visits%20Input%20IO">

<soapenv:Header>

<UsernameToken xmlns="http://siebel.com/webservices">SADMIN</UsernameToken>

<PasswordText xmlns="http://siebel.com/webservices">SADMIN</PasswordText>

<SessionType xmlns="http://siebel.com/webservices">None</SessionType>

</soapenv:Header>

<soapenv:Body>

<cus:query_Input>

<ls:ListOfLsClinicalProtocolSite_SiteVisitsInputIo>

<ls:ClinicalProtocolSiteQuery>

<ls:UserId>SIAADMIN</ls:UserId>

<ls:ProtocolNumber>*</ls:ProtocolNumber>

</ls:ClinicalProtocolSiteQuery>

</ls:ListOfLsClinicalProtocolSite_SiteVisitsInputIo>

<cus:PageSize>2</cus:PageSize>

<cus:StartRowNum>0</cus:StartRowNum>

</cus:query_Input>

</soapenv:Body>

</soapenv:Envelope>

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