topic Re: Need Help to convert shell / cURL into sas code in SAS Programming

Need Help to convert shell / cURL into sas code

alepage — Fri, 24 Feb 2023 13:59:38 GMT

Hello,

Here's the shell / cURL code:

curl --request POST \ --url https://yul1.qualtrics.com/API/v3/directories/directoryId/mailinglists/mailingListId/transactioncontacts \ 
--header 'Content-Type: application/json' \ 
--header 'X-API-TOKEN: token-value' \ 
--data '{ "transactionMeta": { "batchId": "BT_ZZZZ45678901234", "fields": [ "string" ] }, "contacts": [ { "firstName": "string", "lastName": "string", "email": "string", "extRef": "string", "embeddedData": { "property1": "string", "property2": "string" }, "language": "string", "unsubscribed": true, "transactionData": {} } ] }'

How do we convert this script into sas code ? Could you please provide an example where we add two new contacts and another example where we will provide a json file.

Re: Need Help to convert shell / cURL into sas code

ChrisHemedinger — Fri, 24 Feb 2023 14:15:30 GMT

cURL is usually easy to transcribe into PROC HTTP. Looking at the elements in your cURL script:

method is POST
URL is https://yul1.qualtrics.com/API/v3/directories/directoryId/mailinglists/mailingListId/transactioncontacts
ContentType is application/json
API token is in a header name-value pair (X-API-TOKEN)
Input data (to be sent to Qualtrics) is in the --data argument, this equates to IN= in PROC HTTP.

filename resp temp; proc http method='POST' url="https://yul1.qualtrics.com/API/v3/directories/directoryId/mailinglists/mailingListId/transactioncontacts" CT="application/json" in='{ "transactionMeta": { "batchId": "BT_ZZZZ45678901234", "fields": [ "string" ] }, "contacts": [ { "firstName": "string", "lastName": "string", "email": "string", "extRef": "string", "embeddedData": { "property1": "string", "property2": "string" }, "language": "string", "unsubscribed": true, "transactionData": {} } ] }' out=resp; headers "X-API-TOKEN"="your-token-value"; run; /* Check HTTP response code */ %put &SYS_PROCHTTP_STATUS_CODE &SYS_PROCHTTP_STATUS_PHRASE; /* print response to log */ data _null_; rc=jsonpp('resp','log'); run;

The IN= can also take a filename/fileref, so if your data is in an external JSON file, use that method.

The response from the API, assuming it is JSON, can be read as SAS data using the JSON engine:

libname data json fileref=resp;

Re: Need Help to convert shell / cURL into sas code

alepage — Fri, 24 Feb 2023 14:44:44 GMT

Hello,

I have saw your example at the url:

https://communities.sas.com/t5/SAS-Programming/How-to-make-a-PROC-HTTP-Post-request-by-passing-a-JSON-message/td-p/476946

where you are using the following code which I think is easier to read.

Does the datalines portion will look like that and with or without the apostrophe? Do we put a carriage return line feed to separate each new contact info ?

datalines;

{ "transactionMeta": { "batchId": "BT_ZZZZ45678901234", "fields": [ "string" ] }, "contacts": [ { "firstName": "string", "lastName": "string", "email": "string", "extRef": "string", "embeddedData": { "property1": "string", "property2": "string" }, "language": "string", "unsubscribed": true, "transactionData": {} } ] }

run;

/* Put the body of the JSON content in external file */
filename json_in temp;
data _null_;
file json_in;
input;
put _infile_;
datalines;
{ "name":"value" }
run;

Re: Need Help to convert shell / cURL into sas code

ChrisHemedinger — Fri, 24 Feb 2023 15:15:47 GMT

If you use that approach (which I agree is more readable), you can put the JSON content on multiple lines, as long as the complete data remains valid JSON. Break the lines at sections like commas or braces, not in the middle of quoted values.