Your SAS programs, embedded in web apps and elsewhere

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

Reply
New Contributor
Posts: 4

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

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

SAS Super FREQ
Posts: 683

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

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

SAS Employee
Posts: 285

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

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

 

Ask a Question
Discussion stats
  • 2 replies
  • 260 views
  • 2 likes
  • 3 in conversation