Understanding Validating Prompt Table and Translate Field Values
PeopleSoft delivers a a PTLOOKUP service and a REST-based PTLOOKUP_REST service that enables integration partners to retrieve lists of valid/allowable values for prompt and translate (XLAT) fields from PeopleSoft components on which component interfaces are based, allowing them to validate their client application data against PeopleSoft data.
PTLOOKUP Service
To use the PTLOOKUP service, you generate a WSDL document for this service using the Provide Web Service wizard and furnish your integration partner the WSDL document. The third-party integration partner uses the provided request message shape contained in the WSDL document to specify the field values to validate. They then send the request message to the PeopleSoft system to invoke the service. The PeopleSoft system returns a response message to the integration partner with the field values requested.
The PTLOOKUP service contains two service operations:
|
Field or Control |
Definition |
|---|---|
| PTLOOKUPPROMT.v1 |
Use this service operation to return prompt table field values for prompt tables contained in a component. |
| PTLOOKUPXLAT.v1 |
Use this service operation to return translate (XLAT) field values for translate fields contained in a component. |
Each service operation is synchronous and is delivered with a request message, a response message, a handler, and a routing. The delivered metadata for these service operations is described elsewhere in this section.
The service operations take as their primary inputs the value being validated, the name of the table, and the field name against which to compare. The service operations compare the input value against the lookup table and return the result of the validation test.
PTLOOKUP_REST Service
To use the PTLOOKUP_REST service, you generate a WADL document for this service using the Provide Web Service wizard and furnish the WADL document to your integration partner. to generate The third-party integration partner uses the provided request document type message shape to specify the field values to validate. They then use the request URL contained in the WADL document to invoke the service on the PeopleSoft system. The PeopleSoft system returns a response message to the integration partner with the field values requested.
The PTLOOKUP_REST service contains two service operations:
|
Field or Control |
Definition |
|---|---|
| PTLOOKUPPROMPT_REST_GET.v1 |
Use this service operation to return prompt table field values for prompt tables contained in a component. |
| PTLOOKUPXLAT_REST_GET.v1 |
Use this service operation to return translate (XLAT) field values for translate fields contained in a component. |
Each service operation is synchronous and is delivered with pre-defined URI templates, a document template, request and response messages, and any-to-local routing definitions. The delivered metadata for these service operations is described elsewhere in this section.
The service operations take as their primary inputs the value being validated, the name of the table, and the field name against which to compare. The service operations compare the input value against the lookup table and return the result of the validation test.