Web Service parameter

Reply
Contributor
Posts: 50

Web Service parameter

[ Edited ]

Hi,

 

I m trying to set up a web service. 

 

So for this is my code and it is working:

 

 

%Global g_Date;

LIBNAME Star2 Meta Library = "Prod Starschema 2";
LIBNAME _XMLOut XML;

DATA _Null_;
CALL symputx('g_Date', put(today() - 1, 8.));
Run;

PROC SQL OUTOBS=10;
Create Table _XMLOut.test As
Select *
From star2.FACT_ORDER
Where ShipmentDate EQ &g_Date.;
quit;

 

Now I would like to use a parameter with the POST method, like this:

 

<fo> 
<parameters> 
<g_Date>'01Feb2018'd</g_Date> 
</parameters>
</fo>

I added the parameter to the stored process and redeployed it as a web service, but it doesnt work.

 

This is the error I get:

 

<html><head><title>Error report</title></head><body><h1>HTTP Status 500 - Request processing failed; nested exception is com.sas.web.services.WSException: SAS completed with nonzero SYSCC '1.012'.  SYSMSG: ''.</h1></body></html>

 

Can someone please give me a hint?

 

Thanks!

Dirk

Ask a Question
Discussion stats
  • 0 replies
  • 301 views
  • 0 likes
  • 1 in conversation