proc http Qualtrics.com

[alepage]

Hello,

I have getting the surveyid from a previous script (not included).

and I am able to execute the script below but, I am unable to replace the surveyID by it macro variable .

Does someone know how to do that ?

%let SurveyID=SV*************MwSAyrGK;

options set=SSLREQCERT="allow";
filename rsp temp;
proc http
url="https://ca1.qualtrics.com/API/v3/responseexports/"
method= "POST"
in='{"format" : "csv","surveyId" : "SV******QMwSAyrGK"}'
out=rsp;
 headers   
   'x-api-token'= &Api_Token.
   'Content-Type'='application/json';
run;
But I would like to replace the value of the surveyid by a macro variable for safety purpose and automation.

[FreelanceReinh · Accepted solution]

Hello @alepage,

---

@alepage wrote:

I am unable to replace the surveyID by it macro variable .

---

Because the single quotes prevent the resolution of &SurveyID? If so, use double quotes instead and duplicate the inner double quotes:

in="{""format"" : ""csv"",""surveyId"" : ""&SurveyID""}"