topic Get stored process parameters through REST service api (SAS 9.4 BI Web Services) in Developers

Get stored process parameters through REST service api (SAS 9.4 BI Web Services)

shamdan — Mon, 12 Dec 2016 18:27:56 GMT

Hi,

Do you know if there is a way through the REST webservices interface in SAS 9.4 to query what are the parameters that a stored process takes as input?

Previously in the 9.2 foundation services one is able to query what are the parameter names and types that a specific stored process takes as input. I believe this was done using RMI to the Metadata Server. I can't find anywhere in the documentation where we can query a stored process through the BI web services (REST) for the parameters it uses.

Thanks

Re: Get stored process parameters through REST service api (SAS 9.4 BI Web Services)

BrunoMueller — Mon, 12 Dec 2016 20:00:02 GMT

One can get the WSDL of a Stored Process, this will also return input- and outputparameters defined. You simply add "?wsdl" after the call to the Stored Process (WebService), see example below.

The returned value is a XML that describes the Stored Process and its parameters as they are surfaced to the WebService

http://host:port/SASBIWS/services/sasfolderPath/stpName?wsdl

I am not aware of a REST service, that will give this information for a stored process, unless you build it yourself.

Bruno

Re: Get stored process parameters through REST service api (SAS 9.4 BI Web Services)

Vince_SAS — Wed, 04 Jan 2017 13:57:01 GMT

You can also try this (no space between colon and "port"):

http://host: port/SASStoredProcess/do?_action=properties,xml&_program=/sasfolderPath/stpName

Vince DelGobbo

SAS R&D