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
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
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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.