Having issue to make a PROC HTTP Post request by passing a JSON message

niejung — Tue, 07 Jul 2020 17:54:40 GMT

I need help! I had been trying to make a PROC HTTP POST request by passing a JSON message and kept getting 503 service unavailable. I did the POST request call in postman and worked successfully and data was returned. I am running in 9.4m3 SAS linux env.

It is using basic authentication to pass security for URL. url="https://cash-fulfillment-api-sit01.ext-sit.ocp.paasfhlmcnp.com/api/pricing/cash/v1.0/cashWindowAccounting"

json_in file format is

{
  "PricingRequestMetaData": {
    "CorrelationIdentifier": "949cf51d-3689-4d51-966f-8a193fd1487c",
    "RequestTime": "06/18/2020 09:10:10",
    "PricingRequestUserId": "f254202"
  },
  "PricingRequestPayload": {
    "SifmaSettlementDate": "2020-07-27",
    "PriceAsOfDateTime": "2020-05-31 11:59:59",
    "PricingRequestItems": [
      {
        "BenchmarkSecurityProduct": "FHLMC ARM CMS 3/1 2/2/5"
      }
    ]
  }
}

Program Code

filename json_in "/fmac/dev/cor/cwa/src/ctrl_arm_setting.json";
filename out TEMP;

proc http   
   url="https://cash-fulfillment-api-sit01.ext-sit.ocp.paasfhlmcnp.com/api/pricing/cash/v1.0/cashWindowAccounting" 
   method="POST"
   webusername="xxxxxxxx"
   webpassword="xxxxxxxx"
   in=json_in
   out=out;
run;

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

Re: Having issue to make a PROC HTTP Post request by passing a JSON message

smantha — Tue, 07 Jul 2020 19:12:18 GMT

can you try the following and see if you are able to access the url

curl -v -H "Content-Type: application/json" -X POST --data @params.json -u your_username:your_password <url>

Re: Having issue to make a PROC HTTP Post request by passing a JSON message

niejung — Wed, 08 Jul 2020 00:19:01 GMT

I just learn how to use curl command today from SAS support and found the root cause. Sever side’s certificate expired. Your information is exactly the same I tried. Thank you!!!!

topic Re: Having issue to make a PROC HTTP Post request by passing a JSON message in SAS Programming

Having issue to make a PROC HTTP Post request by passing a JSON message

Re: Having issue to make a PROC HTTP Post request by passing a JSON message

Re: Having issue to make a PROC HTTP Post request by passing a JSON message