Bookshelf Home | Contents | Index | PDF     

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

Exporting Clinical Trial Site Visit Data from Siebel Clinical

The SWILSClinicalQueryProtocolSite_SiteVisits Web service is used by third-party applications to request site monitor, clinical trial 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 clinical trial site visit data to a third-party application.

Table 11. SWILSClinicalQueryProtocolSite_SiteVisits XML Queries Supported for Exporting Clinical Trial 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 clinical trial sites, site visits, and protocols which that User ID is associated with.

User ID must be a trial site visit team member listed in the Assigned To list for the site visit. For more information on the site visit Assigned To list, see Creating and Managing Clinical Trial 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 trial site visit 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 clinical trial site and site visit records associated with user SIAADMIN.

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

For more information on configuring the Web service SWILSClinicalQueryProtocolSite_SiteVisits, see Siebel CRM Web Services Reference.

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