topic Creating a REST webservice with JSON input in SAS Programming

Creating a REST webservice with JSON input

RichardP — Fri, 21 Aug 2020 12:18:05 GMT

Hello,

can someone please point me in the right direction. I have created a REST web service with accepts XML input. I now would like to change this to JSON. However I am having difficulty specifying this in the Stored Process Data screen. Is this the correct method?

When I run the following code, I get a Bad Request message as response. Any help would be be very much appreciated!

filename input TEMP;

data _null_;
file input;
input;
put _infile_;
datalines;
{ "name":"value" }
run;

proc http
url="http://blah.com/SASBIWS/rest/storedProcesses/Products/SAS Intelligence Platform/Samples/stp_04_json_json"
in=input
out=resp username=xxx" password="xxx" ;
headers "Content-Type"="application/json" "Accept"="application/json";
run;

Re: Creating a REST webservice with JSON input

RichardP — Fri, 21 Aug 2020 15:29:26 GMT

when looking at the following documentation it would appear to be possible -

however I continue to receive a bad request when specifiying the JSON in the documented manner.

Re: Creating a REST webservice with JSON input

ChrisHemedinger — Wed, 26 Aug 2020 12:23:40 GMT

Hi @RichardP -

To me it looks like you are doing this correctly. But maybe @Vince_SAS has some ideas of what you can check.