topic Re: SAS DI Web Service Output Message in Developers

SAS DI Web Service Output Message

Grumbler — Fri, 09 May 2014 09:38:38 GMT

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.

Thanks.

Re: SAS DI Web Service Output Message

Quentin — Fri, 09 May 2014 13:53:18 GMT

Hi,

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.

HTH,

---Q.

Re: SAS DI Web Service Output Message

Grumbler — Fri, 09 May 2014 14:07:09 GMT

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.

Thanks Q.

Re: SAS DI Web Service Output Message

Quentin — Fri, 09 May 2014 15:32:22 GMT

I could be way off base... my knowledge of developing web services is close to 0.

Re: SAS DI Web Service Output Message

Grumbler — Wed, 11 Mar 2015 09:01:43 GMT

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.