AnsweredAssumed Answered

How to correctly read table values from a request using webservices or DB Query in PAM

Question asked by walxarus on Dec 5, 2016
Latest reply on Dec 12, 2016 by walxarus


Hello, what is the best way to read the form of a Service Catalog requirement?
Especially when there are tables in the form.

 

if I use DB query I got the values, for example:

 

 

 

select form_elem_name,  form_elem_value from usm_request_item_form left join usm_subscription_detail on subscription_detail_id=usm_subscription_detail.id where request_id =  ******  and subscription_type=5 order by request_id desc

 

 

If I use webservices I can get the labelvalues, values and labels which seems great to me. But if the requirement has a table the getFormRateItemValues method does not work.
<soapenv:Fault xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode>soapenv:Server.generalException</faultcode>
<faultstring>Exception occurred in getFormRateItemValues.</faultstring>
<detail>
<ns1:exceptionName xmlns:ns1="http://xml.apache.org/axis/">com.ca.usm.soap.axisInterfaces.WebServiceException</ns1:exceptionName>
<ns2:hostname xmlns:ns2="http://xml.apache.org/axis/">vmdeadmsdl01</ns2:hostname>
</detail>
</soapenv:Fault>
I would like to get the labels of the fields using a query to the database, which table should I relate to? (Usm_form_entities)? How? What is the best way? Thank you!
 
 
 

Outcomes