Example 3: Filtering Field Values by Name/Value Pairs

The following code example shows a request message sent to a PeopleSoft system from an integration partner as part of the PTLOOKUPPROMPT service operation to obtain a list of field values from the Currency table of currencies from Argentina that start with A by using name/value pair as additional filter:

<?xml version="1.0"?>
<soapenv:Envelope xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/
" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:wsa="http:
//schemas.xmlsoap.org/ws/2003/03/addressing/" xmlns:xsd="http://www.w3.org/
2001/XMLSchema/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance/">
  <soapenv:Header xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <wsse:Security soap:mustUnderstand="1" xmlns:soap="http://schemas.
    xmlsoap.org/wsdl/soap/" xmlns:wsse="http://docs.oasis-open.org/wss/
    2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
      <wsse:UsernameToken>
        <wsse:Username>username/wsse:Username>
        <wsse:Password>password</wsse:Password>
      </wsse:UsernameToken>
    </wsse:Security>
  </soapenv:Header>
<soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
  <Lookup xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/
   PT_Lookup.Prompt_Lookup_All.V1">
     <LookupRecName>CURRENCY_CD_TBL</LookupRecName>
     <LookupFieldName>CURRENCY_CD</LookupFieldName>
     <LookupFieldValue>A%</LookupFieldValue>
     <DescrFieldName>DESCR</DescrFieldName>
     <LanguageCode></LanguageCode>
     <EffectiveDate/>
     <SetControlFieldValue/>
     <SetIDValue/>
     <NameValPair xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/
     PT_Lookup.NameValPair.V1"><FldName>COUNTRY</FldName>
        <FldVal>ARG</FldVal>
     </NameValPair>
  </Lookup>
  </soapenv:Body>
</soapenv:Envelope>

The following code example shows the response message that the PeopleSoft system returns to the integration partner. The returned field values are returned in the <RespVal> and <RespDescr> elements, as highlighted in the example:

<?xml version="1.0"?>
<soapenv:Envelope xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/
" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd=
"http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/
XMLSchema-instance">
    <soapenv:Body>
        <LookupResponse xmlns="http://xmlns.oracle.com/Enterprise/Tools/
        schemas/PT_Lookup.LookupResponse.V1">
            <ResponseComp xmlns="http://xmlns.oracle.com/Enterprise/Tools/
            schemas/PT_Lookup.ResponseComp.V1">
                <RespVal>ARS</RespVal>
                <RespDescr>Argentine Peso</RespDescr>
            </ResponseComp>
        </LookupResponse>
    </soapenv:Body>
</soapenv:Envelope>