05-09-2014 05:38 AM
Hello, so I created a SAS STP and then made a Web Service from it. It runs fine in SoapUI. But the return doesn't tell me if it finished or not.
I can check the log myself to find out but users won't be able to do that.
How do I create output message for the Web Service in DI so that it returns a message?
Just a simple Finished or Error would be fine.
05-09-2014 09:53 AM
I'm not going to be much help, but I hope sometimes my questions are helpful to others who can then help...
1. So you have a SAS stored process, the purpose of which is to do some data processing (ETL), rather than return a report. Is that right?
2. How will users call this stored processs? I'm confused by the reference to DI (Data Integration Studio). They will call the stored process from DI Studio? Or via a web page?
If they call the stored process from DI studio, I would think they could check the log in DI studio themselves. And not sure why you would need to make the stored process a web sevice.
If they call the stored process from a web page, then the stored process could end by sending an html page saying "complete" or "error" or whatever to _webout. And there are plenty of papers on automated log scanning, if you want to go that route.
05-09-2014 10:07 AM
Yes. All it does is some data processing. Don't need to return anything.
I am not sure exactly how the users will call. However they want to use it. They will just trigger it so the data processing gets done.
What I meant by DI is that I created the STP in DI and also created WS in DI (automatically).
Ah, _webout. I think I have seen it somewhere. Let me do some research on that.
03-11-2015 05:01 AM
when you create the STP, there is a tab where you can specify the output parameters. you can check &syscc macro variable to output the message. so when you run from soapui, you will see the return value there as well. hope that helps.