How to define inputs in proc http?

Mayt — Thu, 27 Jul 2023 04:36:39 GMT

Hi everyone

I've tried to use proc http to call intelligent decision api in sas studio but it I didn't got expected response as I got in postman. It showed 415 unsupported media type in log tab. Do yo guys know how to fix it? please let me know.

response in postman

What I've tried; all I got was 415 unsupported media type

filename rept temp;
proc http
	url = &url.
	out = rept
	method = "post"
	in = form  ("Fg_1m_6m_"="0"
			    "Fg_2m_6m_"="0"
			    "Wd_3m_"="0"
			    "AvgOut_3m_6m_"="0.25713"
				"Avgdr_9m_"="0.11111"
				"TermOverDueAR_"="0");
	headers 
    	"Authorization" = &token.;
run;

filename rept temp;
proc http
	url = &url.
	out = rept
	method = "post"
	in='{"inputs":[{"name": "Fg_1m_6m_", "value": 0},{"name": "Fg_2m_6m_", "value": 0},{"name": "Wd_3m_", "value": 0},{"name": "AvgOut_3m_6m_", "value": 0.25713},{"name": "Avgdr_9m_", "value": 0.11111},{"name": "TermOverDueAR_", "value": 0}]}';
	headers 
    	"Authorization" = &token.;
run;

filename rept temp;
proc http
	url = &url.
	out = rept
	method = "post"
	in= 'Fg_1m_6m_=0&Fg_2m_6m_=0&Wd_3m_=0&AvgOut_3m_6m_=0.25713&Avgdr_9m_=0.11111&TermOverDueAR_=0';
	headers 
    	"Authorization" = &token.;
run;

filename json_in temp;
data _null_;
file json_in;
input;
put _infile_;
datalines;
	{"Fg_1m_6m_":0}
	{"Fg_2m_6m_":0}
	{"Wd_3m_":0}
	{"AvgOut_3m_6m_":0.25713}
	{Avgdr_9m_":0.11111}
	{"TermOverDueAR_":0}
	;
run;
filename rept temp;
proc http
	url = &url.
	out = rept
	method = "post"
	in =json_in;
	headers 
    	"Authorization" = &token.;
run;

filename rept temp;
proc http
	url = &url.
	out = rept
	method = "post"
	in= 'Fg_1m_6m_=0&Fg_2m_6m_=0&Wd_3m_=0&AvgOut_3m_6m_=0.25713&Avgdr_9m_=0.11111&TermOverDueAR_=0';
	headers 
    	"Authorization" = &token.;
run;

filename json_in TEMP;
data _null_;
file json_in;
put '{';
put '"name": "Fg_1m_6m_", "value": 0,';
put '"name": "Fg_2m_6m_", "value": 0,';
put '"name": "Wd_3m_", "value": 0,';
put '"name": "AvgOut_3m_6m_", "value": 0.25713,';
put '"name": "Avgdr_9m_", "value": 0.11111,';
put '"name": "TermOverDueAR_", "value": 0,';
put '}';
run;

filename resp TEMP;
proc http 
   METHOD="POST" 
   url=&url.
   in=json_in
   out=resp
   oauth_bearer = sas_services;
   headers 'Authorization'=  &token;
   run;
libname resp clear;
libname resp json;

filename resp TEMP;
proc http METHOD="POST" 
   url=&url.
   in='{"name": "Fg_1m_6m_", "value": 0},{"name": "Fg_2m_6m_", "value": 0},{"name": "Wd_3m_", "value": 0},{"name": "AvgOut_3m_6m_", "value": 0.25713},{"name": "Avgdr_9m_", "value": 0.11111},{"name": "TermOverDueAR_", "value": 0}'
  out=resp
  oauth_bearer = sas_services;
   headers 'Authorization'=&token.;
   run;
libname resp clear;
libname resp json;

Re: How to define inputs in proc http?

ChrisHemedinger — Thu, 27 Jul 2023 16:25:19 GMT

Of the examples you provided, #2 looks the closest/most correct. The PROC HTTP data should be the same JSON you supply in Postman. Also, be sure to add the CT= option for this call to tell the API what to expect:

'Content-Type': 'application/vnd.sas.microanalytic.module.step.input+json'

Re: How to define inputs in proc http?

Mayt — Wed, 02 Aug 2023 03:02:23 GMT

It worked!! Thank you very much.

topic How to define inputs in proc http? in SAS Programming

How to define inputs in proc http?

Re: How to define inputs in proc http?

Re: How to define inputs in proc http?