Querying Sites in Siebel Clinical

This API is used to query the Site details from Siebel Clinical. Along with Site information, it fetches all Contacts, Accounts and Addresses information from the particular Site.

Protocol Number is the required field in the payload. You must provide a valid Protocol Number in the payload.

The following sample request will query all Sites under given Protocol in Siebel Clinical:

URI: https://ServerName:port/siebel/v1.0/service/LS Clinical Protocol Site Query/querypage/
HTTP Method: POST
Content-Type: application/json
Authorization: Basic

Request body:

{
  "body": {
    "Protocol Number": "PT_Protocol_001",
    "PageSize": "100",
    "StartRowNum": "0"
  } 
}

Here are the response details for a successful request:

HTTP Code: 200
Content-Type: application/json

Response body:

{
    "NumOutputObjects": "2",
    "ResponseMessage": "Success",
    "LastPage": "true",
    "SiteData": {
        "IntObjectFormat": "Siebel Hierarchical",
        "MessageId": "88-873FX",
        "IntObjectName": "LS Clinical Protocol Site Query IO",
        "MessageType": "Integration Object",
        "Sites": [
            {
                "PI Salutation": "Dr.",
                "Site Number": "CT_Site_002",
                "PI Email": "sbaniker@line.com",
                "Site Row Id": "88-3H91E",
                "Site Time Zone": "",
                "Site Created": "12/12/2013 00:58:19",
                "Site Name": "Hibbing Mfg",
                "Site Initiation Date": "06/01/2013",
                "Protocol Number": "CT_Protocol_002",
                "Status": "Planned",
                "PI Phone Number": "2013254455",
                "PI Last Name": "Baniker",
                "Site Updated": "03/06/2014 12:18:43",
                "PI First Name": "Steven",
                "Contacts": {
                    "Site State": "",
                    "Site Contact Role": "Principal Investigator",
                    "Site Country": "",
                    "Site Contact Fax": "2013254466",
                    "Site Contact Last Name": "Baniker",
                    "Site Contact Created": "12/12/2013 00:59:30",
                    "Site Province": "",
                    "Site Zip": "",
                    "Site Contact Updated": "12/12/2013 00:59:30",
                    "Site Contact First Name": "Steven",
                    "Site City": "",
                    "Site Address 2": "",
                    "Site Address 1": "",
                    "Site Contact Phone": "2013254455",
                    "Site Contact Email": "sbaniker@line.com"
                },
                "Addresses": {
                    "Site State": "CA",
                    "Site Address Type": "Payment",
                    "Site Address Updated": "12/12/2013 01:12:53",
                    "Site Country": "Russia",
                    "Site Address Name": "Address2",
                    "Site Province": "Quebec",
                    "Site Zip": "84944-6888",
                    "Site Address Created": "12/12/2013 01:03:24",
                    "Site City": "Actaeon",
                    "Site Address 2": "",
                    "Site Address 1": "27189 Lovelace Rd., Igor, Ri"
                }
            },
            {
                "PI Salutation": "",
                "Site Number": "CT_Site_005",
                "PI Email": "",
                "Site Row Id": "88-3KNL6",
                "Site Time Zone": "",
                "Site Created": "03/06/2014 12:10:39",
                "Site Name": "Hibbing Mfg",
                "Site Initiation Date": "",
                "Protocol Number": "CT_Protocol_002",
                "Status": "Planned",
                "PI Phone Number": "",
                "PI Last Name": "Adler",
                "Site Updated": "03/06/2014 12:18:02",
                "PI First Name": "Mike",
                "Contacts": {
                    "Site State": "",
                    "Site Contact Role": "Principal Investigator",
                    "Site Country": "",
                    "Site Contact Fax": "",
                    "Site Contact Last Name": "Adler",
                    "Site Contact Created": "03/06/2014 12:11:54",
                    "Site Province": "",
                    "Site Zip": "",
                    "Site Contact Updated": "03/06/2014 12:11:54",
                    "Site Contact First Name": "Mike",
                    "Site City": "",
                    "Site Address 2": "",
                    "Site Address 1": "",
                    "Site Contact Phone": "",
                    "Site Contact Email": ""
                }
            }
        ]
    }
}