Skip to Main Content

Integration

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Extract delimited text in Oracle BPM

Robinson JOct 15 2018 — edited Oct 17 2018

Hi Experts

I have a payload within the BPM Process where a webservice returns me a list of approvers ex: tom,lee,Ben which are basically users. My requirement is to extract these users individually and assign to a node which is like target node below

Source Node

<xs:complexType name="approvalRouteByInvoiceNatureResponse">

    <xs:complexContent>

      <xs:extension base="tns:messageValueObject">

        <xs:sequence>

          <xs:element type="xs:string" name="approvalRoute" minOccurs="0"/>

          <xs:element type="xs:boolean" name="autoApprove" minOccurs="0"/>

          <xs:element type="tns:integrationResponse" name="integrationResponse" minOccurs="0"/>

          <xs:element type="tns:statusResponse" name="statusResponse" minOccurs="0"/>

        </xs:sequence>

      </xs:extension>

    </xs:complexContent>

  </xs:complexType>

and the target node would look like

<?xml version="1.0" encoding="windows-1252" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"

            xmlns="http://www.example.org"

            targetNamespace="http://www.example.org"

            elementFormDefault="qualified">

  <xsd:element name="ApprovalRoute">

    <xsd:complexType>

    <xsd:sequence>

    <xsd:element name="Approvers" type="xsd:string" minOccurs="0" maxOccurs="unbounded"/>

    </xsd:sequence>

    </xsd:complexType>

  </xsd:element>

</xsd:schema>

The reason being i would like to do some logic on each user,what will be the best way to get the individual users from the webservice ,

Thanks for Help

Robin

Comments
Post Details
Added on Oct 15 2018
7 comments
371 views