We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

How to handle events overlapping for a particular questionnaire and a single patient?



  • lulzimfazlijalulzimfazlija Posts: 14
    @GerbenRienk I could not get any response from the endpoint you have shown, are these web services SOAP WSDL?

    I am trying this directly on the web browser: https://www.mydomain:8443/OpenClinica/rest/clinicaldata/xml/view/S_PROSPER1/SS_KS1014/*/* nothing showing up.

    Normally other web services are something like this:

  • GerbenRienkGerbenRienk Posts: 838 ✭✭✭
    This is a REST-webservice and you must first login.
  • lulzimfazlijalulzimfazlija Posts: 14
    Are there such endpoint for SOAP Web Service, as I have already chosed to work with SOAP Web Service, due I had trouble authentication accessing Rest API.

  • lulzimfazlijalulzimfazlija Posts: 14
    also I am getting this error after login:
    Oops! An error has occurred

    This can be for a number of reasons, which may or may not have to do with the OpenClinica application. If there are any system messages above this text, please copy and paste them into the Report Issue Form.
  • GerbenRienkGerbenRienk Posts: 838 ✭✭✭
    Can you try the following:
    - take any subject in your study and click on the magnifier icon in the right column of the subjectmatrix
    - you are now in the ViewStudySubject form
    - click on Subject Case Book
    - select CDISC ODM XML or JSON
    - click button Open
    Kind regards,
    Gerben Rienk
  • lulzimfazlijalulzimfazlija Posts: 14
    edited June 2017
    thnx @GerbenRienk for you answers. I think I should also see how Rest Api Auth how
    it works... as I had difficulties to manage working that, I think I should somehow add username and the password encoded into headers when calling this endpoint.

  • GerbenRienkGerbenRienk Posts: 838 ✭✭✭
    edited June 2017
    In what language will you use the rest-call?
    In VB it would be something like
    Set objREST = CreateObject("MSXML2.XMLHTTP.6.0")
    strURL = "https://www.mydomain:8443/OpenClinica/j_spring_security_check?j_username=" & UName & "&j_password=" & PWord
    objREST.Open "POST", strURL, False

    strURL = "https://www.mydomain:8443/OpenClinica/"
    strURL = strURL & "rest/clinicaldata/xml/view/" & StudyOID & "/" & StudySubjectID & "/*/*"

    'calling REST'
    objREST.Open "GET", strURL, False

    'send request to the REST url'

    'the responsetext must be transformed'
    strClinicalDataXML = objREST.responseText
    Or in python something like:
    import requests
    import xml.etree.ElementTree as ET

    # config is a dict with credentials and urls, etc.
    login_url = config['baseUrlRest'] + '/j_spring_security_check'
    login_action = {'action':'submit'}
    login_payload = {
    'j_username': config['userName'],
    'j_password': config['password'],
    mySession = requests.Session()
    cd_url = config['baseUrlRest'] + '/rest/clinicaldata/xml/view/' + config['studyOid'] + '/'
    cd_url = cd_url + self._studysubjectid + '/*/*'
    clinical_data = mySession.get(cd_url)
    Hope this helps,
    Kind regards,
    Gerben Rienk
  • lulzimfazlijalulzimfazlija Posts: 14
    In javascript, but thnx this is already helpful!
Sign In or Register to comment.