topic Re: How to convert a CURL command into PROC HTTP syntax in SAS Programming

How to convert a CURL command into PROC HTTP syntax

Anmolkhandelwal — Mon, 15 Mar 2021 14:07:50 GMT

Hello,

can someone please help me convert the following (working) cURL command into the PROC HTTP equivalent?

curl -d '' -X POST 'https://api.bcda.cms.gov/auth/token' \
	--user 3841c594-a8c0-41e5-98cc-38bb45360d3c:f9780d323588f1cdfc3e63e95a8cbdcdd47602ff48a537b51dc5d7834bf466416a716bd4508e904a \
	-H "accept: application/json"

The parameters under --user are clientid:client secret key

The response which is expected for this request is :

{
"access_token": "eyJhbGciOiJSUzUxMiIsInR5c...",
"token_type":"bearer"
}

Any help is appreciated.

Thanks.

Re: How to convert a CURL command into PROC HTTP syntax

ChrisHemedinger — Mon, 15 Mar 2021 15:12:39 GMT

See this blog post: How to translate your cURL command to PROC HTTP.

It looks like you might end up with something like:

filename resp temp; proc http url="https://api.bcda.cms.gov/auth/token" webuserid="3841c594-a8c0-41e5-98cc-38bb45360d3c:f9780d323588f1cdfc3e63e95a8cbdcdd47602ff48a537b51dc5d7834bf466416a716bd4508e904a" out=resp method="POST"; headers "Accept"="application/json"; run; libname auth JSON fileref=resp; /* use DATA step to get data from AUTH, the JSON response */

Re: How to convert a CURL command into PROC HTTP syntax

Anmolkhandelwal — Tue, 16 Mar 2021 05:51:16 GMT

I tried using the above code, gave me syntax error as below,

27         proc http
28          url="https://api.bcda.cms.gov/auth/token"
29          webuserid="c0a02574-6432-4e65-b8da-cb6f264b4544:c04473622271dd3ffa53ab0c85ed006fa6c0fb59b6d8e3409bd411e396599f7451cd53ae
            _________
            22
            76
29       ! f1b370a4"
ERROR 22-322: Syntax error, expecting one of the following: ;, AUTH_ANY, AUTH_BASIC, AUTH_NEGOTIATE, AUTH_NONE, AUTH_NTLM, 
              CLEAR_CACHE, CLEAR_CONN_CACHE, CLEAR_COOKIES, CT, EXPECT_100_CONTINUE, FOLLOWLOC, HEADERIN, HEADEROUT, 
              HEADEROUT_OVERWRITE, HTTP_TOKENAUTH, IN, METHOD, NOFOLLOW, NOFOLLOWLOC, NO_CONN_CACHE, NO_COOKIES, OUT, PROXYHOST, 
              PROXYPASSWORD, PROXYPORT, PROXYUSERNAME, PROXY_AUTH_BASIC, PROXY_AUTH_NEGOTIATE, PROXY_AUTH_NONE, PROXY_AUTH_NTLM, 
              URL, VERBOSE, WEBAUTHDOMAIN, WEBPASSWORD, WEBUSERNAME.  
ERROR 76-322: Syntax error, statement will be ignored.

Then i changed the webuserid to webusername and webpassword, Got the below error.

26         filename resp temp;
27         proc http
28          url="https://api.bcda.cms.gov/auth/token"
29          webusername="c0a02574-6432-4e65-b8da-cb6f264b4544"
30         	WEBPASSWORD = XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
31          out=resp
32          method="POST";
33         headers "Accept"="application/json";
34         run;

ERROR: OpenSSL error 336032824 (0x14077438) occurred in SSL_connect/accept at line 5388, the error message is "error:14077438:SSL 
       routines:SSL23_GET_SERVER_HELLO:tlsv1 alert internal error".
ERROR: Secure communications error status 807ff008 description "OpenSSL error 336032824 (0x14077438) occurred in SSL_connect/accept 
       at line 5388, the error message is "error:14077438:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert internal error"."
ERROR: Encryption run-time execution error
ERROR: Call to tcpSockContinueSSL failed.

Don't have much idea about such error.

Re: How to convert a CURL command into PROC HTTP syntax

ChrisHemedinger — Tue, 16 Mar 2021 12:30:14 GMT

My mistake - the proper syntax is webusername=.

filename resp temp; proc http url="https://api.bcda.cms.gov/auth/token" webusername="3841c594-a8c0-41e5-98cc-38bb45360d3c:f9780d323588f1cdfc3e63e95a8cbdcdd47602ff48a537b51dc5d7834bf466416a716bd4508e904a" out=resp method="POST"; debug level=2; headers "Accept"="application/json"; run; libname auth JSON fileref=resp; data _null_; rc=jsonpp('resp','log'); run;

According to the API doc they don't want a separate password -- it's all part of the user= value.

The TLS error might be something else though. Make sure you can use PROC HTTP with SSL (certificates need to be in place). Here's how to test.

Re: How to convert a CURL command into PROC HTTP syntax

Anmolkhandelwal — Wed, 07 Apr 2021 06:41:38 GMT

Well we tried the test, it ran through successfully.
however, when we ran the above code, this gave us "Access denied" as the api response and 403 Forbidden as the status code.
Just some additional info, we do have the access for the URL's and right credentials, as we were able to submit successful requests using postman and python.
Any suggestions on if we are missing something while sending the credentials to get a token using above code.
Thanks.

Re: How to convert a CURL command into PROC HTTP syntax

ChrisHemedinger — Wed, 07 Apr 2021 12:29:35 GMT

I think in cURL the --user option has the form "user:password" where the colon separates the user ID from the password. Would you try something like this? Also, the -d option sets the content-type to application/x-www-form-urlencoded. You're not sending any content but I figured I'd set the content type in this call.

filename resp temp; proc http url="https://api.bcda.cms.gov/auth/token" webusername="3841c594-a8c0-41e5-98cc-38bb45360d3c" webpassword="f9780d323588f1cdfc3e63e95a8cbdcdd47602ff48a537b51dc5d7834bf466416a716bd4508e904a" out=resp ct="application/x-www-form-urlencoded" method="POST"; debug level=2; headers "Accept"="application/json"; run;

Re: How to convert a CURL command into PROC HTTP syntax

Anmolkhandelwal — Tue, 13 Apr 2021 05:41:12 GMT

We added options like :set=SSL_USE_SNI="1" set=SSL_SNI_HOSTNAME="URL"; to resolve the SSL issue we had.
The above code worked to get the response from the URL.

Thanks for your help 🙂