topic Send more than output table to the client in SAS DI Job exposed as web service in SAS Data Management

Send more than output table to the client in SAS DI Job exposed as web service

smehae — Wed, 06 Sep 2023 13:36:47 GMT

Dears,

We want to build SAS DI Job that are exposed to return different output tables and the DI job will be exposed as web service ... currently DI job exposed as output service can have only one output file .. how we can include multiple different tables in the response of exposed web service ?

We are using SAS9.4 Platform.

Re: Send more than output table to the client in SAS DI Job exposed as web service

rudfaden — Wed, 04 Oct 2023 10:28:54 GMT

Think you are using the wrong tool. I suggest you use a SAS Stored Process instead.

Re: Send more than output table to the client in SAS DI Job exposed as web service

LinusH — Thu, 05 Oct 2023 11:09:33 GMT

If you happen to licence Enterprise Decision Management with a MAS server component, there's a transformation for that:

https://documentation.sas.com/doc/sv/etlug/4.905/p0n2s8yde3a0yan1o7i5531cgtet.htm

Haven't tested it myself though.

You can also deploy a DI Stdio job as a SAS Stored Process. It's not like a modern service, but similar:

SAS Help Center: About Deploying Jobs as Stored Processes

A Stored process can then be published as a web service:

SAS Help Center: About Deploying Jobs as Web Services

Re: Send more than output table to the client in SAS DI Job exposed as web service

rudfaden — Fri, 06 Oct 2023 05:41:48 GMT

Maybe you should tjek out https://sasjs.io/. They made a framework for web development with SAS