PeopleSoft Connector User Guide

config.server=<HOST:PORT>
config.username=<USERNAME>
config.password=<PASSWORD>
config.componentInterfaceEditHistoryItems=<TRUE_OR_FALSE>
config.componentInterfaceInteractiveMode=<TRUE_OR_FALSE>
config.componentInterfaceGetHistoryItems=<TRUE_OR_FALSE>

<context:property-placeholder location="peoplesoft.properties"/>

<peoplesoft:config name="PeopleSoft" server="${config.server}" username="${config.username}" password="${config.password}" doc:name="PeopleSoft">

<peoplesoft:invoke-operation config-ref="PeopleSoft" key="CI_POSITION_DATA||Find" doc:name="Find Employees" />

 <dw:transform-message doc:name="Map To CI_PERSONAL_DATA">
            <dw:set-payload><![CDATA[%dw 1.0
%output application/java
---
{
        KEYPROP_EMPLID: inboundProperties['http.query.params'].id,
        PROP_NAME: inboundProperties['http.query.params'].name,
        PROP_LAST_NAME_SRCH: inboundProperties['http.query.params'].lastname,
        PROP_NAME_AC: inboundProperties['http.query.params'].nameac
}]]></dw:set-payload>
        </dw:transform-message>

[
    {
    "KEYPROP_EMPLID": "MULE0001",
    "PROP_NAME": "Muley",
    "PROP_LAST_NAME_SRCH": "The Mule",
    "PROP_NAME_AC": ""
    },
    {
    "KEYPROP_EMPLID": "MULE0002",
    "PROP_NAME": "Second Muley",
    "PROP_LAST_NAME_SRCH": "The Backup Mule",
    "PROP_NAME_AC": ""
    },
    ...
]

<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns:dw="http://www.mulesoft.org/schema/mule/ee/dw" xmlns:context="http://www.springframework.org/schema/context"
      xmlns:http="http://www.mulesoft.org/schema/mule/http"
      xmlns:data-mapper="http://www.mulesoft.org/schema/mule/ee/data-mapper"
      xmlns:json="http://www.mulesoft.org/schema/mule/json"
      xmlns:file="http://www.mulesoft.org/schema/mule/file"
      xmlns:peoplesoft="http://www.mulesoft.org/schema/mule/peoplesoft"
      xmlns:doc="http://www.mulesoft.org/schema/mule/documentation"
      xmlns:spring="http://www.springframework.org/schema/beans"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.mulesoft.org/schema/mule/core"
      version="EE-3.7.0"
      xsi:schemaLocation="http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-current.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-current.xsd
http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd
http://www.mulesoft.org/schema/mule/peoplesoft http://www.mulesoft.org/schema/mule/peoplesoft/current/mule-peoplesoft.xsd
http://www.mulesoft.org/schema/mule/file http://www.mulesoft.org/schema/mule/file/current/mule-file.xsd
http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/current/mule-json.xsd
http://www.mulesoft.org/schema/mule/ee/data-mapper http://www.mulesoft.org/schema/mule/ee/data-mapper/current/mule-data-mapper.xsd
http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/current/mule-http.xsd
http://www.mulesoft.org/schema/mule/ee/dw http://www.mulesoft.org/schema/mule/ee/dw/current/dw.xsd">
        <context:property-placeholder location="peoplesoft.properties"/>
        <spring:beans>
        <spring:import resource="classpath:DemoSpringBeans.xml"/>
    </spring:beans>
    <peoplesoft:config name="PeopleSoft" server="${config.server}" username="${config.username}" password="${config.password}" doc:name="PeopleSoft">
        <peoplesoft:component-interface-ids-white-list>
            <peoplesoft:component-interface-ids-white-list>CI_PERSONAL_DATA</peoplesoft:component-interface-ids-white-list>
            <peoplesoft:component-interface-ids-white-list>CI_POSITION_DATA</peoplesoft:component-interface-ids-white-list>
        </peoplesoft:component-interface-ids-white-list>
        <reconnect count="3"/>
    </peoplesoft:config>
    <asynchronous-processing-strategy name="Asynchronous_Processing_Strategy" maxThreads="5" minThreads="2" threadTTL="10" poolExhaustedAction="WAIT"
                                      doc:name="Asynchronous Processing Strategy"/>
    <http:listener-config name="HTTP_Listener" host="0.0.0.0" port="8081" doc:name="HTTP Listener Configuration"/>
    <file:connector name="File" autoDelete="true" streaming="true" validateConnections="true" doc:name="File"/>
    <data-mapper:config name="Employee_Position_Data_to_CI_POSITION_DATA" transformationGraphPath="employee_position_data_to_ci_position_data.grf"
                        doc:name="Employee_Position_Data_to_CI_POSITION_DATA"/>
    <data-mapper:config name="Employee_Data_to_CI_PERSONAL_DATA" transformationGraphPath="employee_data_to_ci_personal_data.grf"
                        doc:name="Employee_Data_to_CI_PERSONAL_DATA"/>

    <flow name="Find_Employee_Flow">
        <http:listener config-ref="HTTP_Listener" path="/find" doc:name="HTTP"/>
        <dw:transform-message doc:name="Map To CI_PERSONAL_DATA">
            <dw:set-payload><![CDATA[%dw 1.0
%output application/java
---
{
        KEYPROP_EMPLID: inboundProperties['http.query.params'].id,
        PROP_NAME: inboundProperties['http.query.params'].name,
        PROP_LAST_NAME_SRCH: inboundProperties['http.query.params'].lastname,
        PROP_NAME_AC: inboundProperties['http.query.params'].nameac
}]]></dw:set-payload>
        </dw:transform-message>
        <peoplesoft:invoke-operation config-ref="PeopleSoft" key="CI_PERSONAL_DATA||Find" doc:name="PeopleSoft"/>
        <json:object-to-json-transformer doc:name="List&lt;CI_PERSONAL_DATA&gt; To JSON"/>
        <logger level="INFO" doc:name="Employee List" message="#[payload]"/>
    </flow>
</mule>