From a CATALOG form, we’re using field sets into as a records into a Table object. This is to induce users to introducing information in a structured way.
By a functionality point of view, the form lets to user to introduce records of information as often as you need.
But I have inconveniences to retrieve these records were introduced in these table fields.
Could you helpme to understand about how to can retrieving these records stored into an Table object by PAM (4.3) or CATALOG (14.1)?
Or some documentation to accomplish this?
Get table values
Extract table data Catalog 12.7
to clarify my point:
- I've a Table object with title "DETALLE DE ARTICULOS, into a Catalog form
- the users add & save rows according your own needs
- I'm looking a method or way to retriving the values saved in this Table object
- could be gets about Catalog web services
- may be web services a valid way? If yes, where i can lear about Catalog web ?
You can leverage the getFormRateItemValue(s) web service methods (Administration > Tools > Links > Web Services API > Request Web Service) to return the form data or you can pass the form data to the PAM process via events-rules-actions using $form_data_sd$ or $form_data_sd_row$ Request Subscription Item Change event type parameters:
Event Parameters - CA Service Management - 14.1 - CA Technologies Documentation
Thank you Jason_Wolfe
In My PAM process, trough web service operator, I doing login into Catalog and returns this value as Session Id: 8792b0c729e5f69c8e8fd09b0ceffdabe0e0d616. Honestly I don’t know if this value or format is correct.
After to do this, I use another web service operator to invoke “getFormRateItemValue” method. This autogenerated this code:
I supposed that fills these to this way:
The current issue is that the “getFormRateItemValue“ operator execution fails with this message:
Artifact Session is invalid
Then, what’s about refers “Artifact Session is invalid”?
It sounds like you may not be passing the session ID returned via login method to getFormRateItemValue method. While the 'Inline text' autogenerates the inputs, you need to ensure you are passing the variable (that you saved the session ID to from the login method) to the 'sessionID__' variable using dynamic parameters similar to the following:
Macro name-X-Path: SESSIONID__
Type: String Value
In this case the inline text variable 'SESSIONID__' will be replaced by the value of the process variable 'SLCM_SessionID__' which has the actual session ID.
I would recommend taking a look at the OOTB processes as a reference.
subscriptionDetailID is the ID of the form item, not the request ID:
select id from usm_subscription_detail where request_id=<request id> and subscription_type=5 (subscription_type=5 is the form element)
formRateItemName is the _id of the form field you would like to return, not the _id of the form
I could also suggest testing the web services first in a tool like soapUI to verify the inputs/output before trying in PAM.
i'm very happy, your recomendations were very useful to solve my question.
Thank you very much!