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

[shamdan]

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

[BrunoMueller]

Hi

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

[Vince_SAS]

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