Hi,
I use a 2 step approach:
first read your study metadata where you can find all the forms that are defined in your study build
based on above list you can download each form data no matter what exact study you are using (it is metadata driven, so with a few parameters you can use this for multiple studies)
if you are using this in LSAF you most likely need to add a proxy and request to SAS professional services (jira ticket) to open that specific port in their network so that LSAF can connect to Medidata RWS (webservices)
example for metadata::
https://url.mdsol.com/RaveWebServices/datasets/Clinicalviewmetadata.csv?projectname=studyID replace URL with your medidata URL and studyID with the study you need
form data extraction= proc http proxyhost="webproxy.vsp.sas.com" proxyport=3128
out=clindata url="https://URL.mdsol.com/RaveWebServices/datasets/V_studyID_FormID.csv?environmentName=prod"
headerin=httphead headerout=httpret
method="get"
ct="text/plain;charset=UTF-8"; run;
I use Medidata mAuth for authentication, so that's the reason I need the http input header
output header I use to scan for return message (OK, nok,...)
... View more