About Exporting Data for Site Visits

Third-party applications use the SWILSClinicalQueryProtocolSite_SiteVisits Web service 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 13-1 lists the XML queries that this Web service supports for exporting site visit data to a third-party application.

Table 13-1 XML Queries that SWILSClinicalQueryProtocolSite_SiteVisits Supports 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 associated with that User ID.	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 "Assigning Employees to Site Teams".
<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 associated with that protocol number.	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 associated with that User ID and protocol number.	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

The extract in this topic 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>