topic Re: How to get (a correct) response from a REST-API via SAS 9.4M2? in SAS Programming

How to get (a correct) response from a REST-API via SAS 9.4M2?

SAS_Question — Thu, 26 Sep 2019 09:53:46 GMT

Hi all,

I want to test a REST-API via SAS EG (version 9.4m2, not 3 yet unfortunately!!!)

So what I did is the folowing:

(and sorry for censoring the link and tokens, as I can not share those!)

filename resp "p:\temp\TestAPI.txt";
filename hdrs "p:\temp\HeadAPI.txt";

data _null_;
	file hdrs;
        put "Authorization: Bearer [MyTOKEN key here]";
        put "Accept: application/json";
        put "Accept-Language: nl";
run;

proc http 
	url='https://[censored]/api/2.0/'
	method="GET"
	headerin=hdrs
	out=resp;
run;

But all I get is the homepage in html code in the resp file...?

What I'm doing wrong here? Can someone help please?

Thanks in advance!

Re: How to get (a correct) response from a REST-API via SAS 9.4M2?

JosvanderVelden — Mon, 30 Sep 2019 16:39:42 GMT

Have you seen this post from @M_EEddlestone: https://communities.sas.com/t5/SAS-Data-Mining-and-Machine/Retrieving-Data-with-REST-API/m-p/336178#M5026

Re: How to get (a correct) response from a REST-API via SAS 9.4M2?

SAS_Question — Thu, 06 Feb 2020 11:38:43 GMT

Hi Jos,

Thanks for your reply, and sorry for my late reaction. Was ill for a long time.

Anyway. We filed for a new version of SAS where the calling of an API is much more simpler then with this old version of us.

So will keep you informed when we get this to work with the new version.

Thanks for now!