Retrieving data from a stored process with curl

RobP — Thu, 02 Aug 2018 18:08:50 GMT

I have a simple "Hello World" stored process, and I can successfully call it from my browser and get the results directly by passing in my user/pass credentials as part of the URL request (so the login page never shows).

I'm trying to replicate the above behaviour by passing the same URL to curl, but I keep getting the login screen as a result.

From the browser, the URL looks like:

http://myserver.com:7980/SASStoredProcess/do?
_program=my_program&_username=my_user_name&_password=%7BSAS002%7DEFFF...

From curl (running from a Linux64 bash shell), I've tried a multitude of parameters etc, but my latest version is:

curl -v -L -k -d "_program=my_program&_username=my_user_name&_password=%7BSAS002%7DEFFF..."  
http://myserver.com:7980/SASStoredProcess/do

As I mentioned, it results in the login screen. I've also tried the /do1 request with the same results.

I believe I have everything configured correctly in SAS Management Console, as the request works fine from the browser URL. Where am I going wrong?

Re: Retrieving data from a stored process with curl

AllanBowe — Wed, 08 Aug 2018 13:09:47 GMT

You're just missing the options to read / write cookies (this is where the session token is stored).

Try the following:

curl -v -L -k -c cookiefile -b cookiefile \
    -d "_program=my_program&_username=my_user_name&_password=%7BSAS002%7DEFFF..." \
    http://myserver.com:7980/SASStoredProcess/do

Re: Retrieving data from a stored process with curl

RobP — Wed, 08 Aug 2018 13:50:34 GMT

Yes! That was it... thank you so much!

topic Retrieving data from a stored process with curl in Developers

Retrieving data from a stored process with curl

Re: Retrieving data from a stored process with curl

Re: Retrieving data from a stored process with curl