WSO2 - Read and Iterate xml file - EI or ESB

This post explains how to read and iterate through an XML file. 


For this we are using file connector.


  • To achieve this we could use EI file connector [1].
  • Download the file connector from the connector store [2].
  • We are going to use the read operation of the file connector [3].
  • If you are using EI tooling, you could create a connector project and add it to the car file.
  • OR you could import the connector directly through the management console.
  • Then you could use the following proxy configuration to read the file from a given location
Following is the proxy service.
<?xml version="1.0" encoding="UTF-8"?>
<proxy name="SimpleService" startOnLoad="true" trace="enable" transports="https http" xmlns="http://ws.apache.org/ns/synapse">
    <target faultSequence="fault">
        <inSequence>
            <fileconnector.read>
                <source>file://Users/chanuka/Documents/support/xml</source>
                <filePattern>.*\.xml</filePattern>
            </fileconnector.read>
            <iterate continueParent="true" expression="//Devices/MobileDevice" sequential="true">
                <target>
                    <sequence>
                        <property expression="//MobileDevice/Id/text()" name="MobileDevice" scope="default" type="STRING"/>
                        <property name="CUSTOM_RESPONSE" scope="default" type="STRING" value=""/>
                        <iterate continueParent="true" expression="//User/Devices" id="ITR_AGG">
                            <target>
                                <sequence>
                                    <aggregate id="ITR_AGG">
                                        <completeCondition>
                                            <messageCount max="-1" min="-1"/>
                                        </completeCondition>
                                        <onComplete expression="//Devices">
                                            <foreach expression="//Device" id="foreach_1" xmlns:m0="http://services.samples">
                                                <sequence>
                                                    <property expression="//Id/text()" name="DeviceId" scope="default" type="STRING"/>
                                                    <property expression="//Name/text()" name="DeviceName" scope="default" type="STRING"/>
                                                    <log level="custom">
                                                        <property expression="get-property('DeviceId')" name="DeviceId"/>
                                                    </log>
                                                    <script language="js"><![CDATA[var devicename = mc.getProperty('DeviceName');
var deviceid = mc.getProperty('DeviceId');
        var finaldevicearray = mc.getProperty("CUSTOM_RESPONSE");
        var devicearray ="";
        
        if(finaldevicearray == ""){
        
        devicearray = "{\"devicename\":\"" + devicename + "\",\"deviceid\":\"" +deviceid + "\"}";
        finaldevicearray = devicearray;
        }
        else{
        
        devicearray = ",{\"devicename\":\"" + devicename + "\",\"deviceid\":\"" +deviceid + "\"}";
        finaldevicearray = finaldevicearray + devicearray;
        }
        var str = finaldevicearray.toString();
mc.setProperty("CUSTOM_RESPONSE",str);]]></script>
                                                </sequence>
                                            </foreach>
                                            <log level="custom">
                                                <property expression="get-property('CUSTOM_RESPONSE')" name="CUSTOM_RESPONSE >>>>>"/>
                                            </log>
                                            <payloadFactory media-type="json">
                                                <format>
{
"MobileDeviceId":"$1",
"Devices":[$2]
}
</format>
                                                <args>
                                                    <arg evaluator="xml" expression="get-property('MobileDevice')"/>
                                                    <arg evaluator="xml" expression="get-property('CUSTOM_RESPONSE')"/>
                                                </args>
                                            </payloadFactory>
                                            <respond/>
                                        </onComplete>
                                    </aggregate>
                                </sequence>
                            </target>
                        </iterate>
                    </sequence>
                </target>
            </iterate>
        </inSequence>
        <outSequence/>
    </target>
</proxy>

Comments

Post a Comment

Popular posts from this blog

How to fix SoapUI freeze in Mac OS

Follow these steps carefully, which will fix SoapUI freeze in Mac OS. [Note: Tested in my OS X 10.11.6] Start ‘Activity Monitor’ and Force Kill your dead soapUI process. [Or use Command-Option-Escape to force quit it.] In Finder, /Applications/SmartBear/soapUI-5.0.0.app > Show Package Contents. Edit /Applications/SmartBear/soapUI-5.0.0.app/Contents/ java/app/bin/soapui.sh. Uncomment this line# JAVA_OPTS="$JAVA_OPTS -Dsoapui.browser.disabled=true". [In other words, remove the "#" to stop it being a comment.] Edit /Applications/SmartBear/soapUI-5.0.0.app/Contents/ vmoptions.txt. Add -Dsoapui.browser.disabled=true. Start soapUI. [In those paths, change  soapUI-5.0.0  to match your version. For me it is  soapUI-5.1.3 .] Referenced from:  https://community.smartbear.com/t5/SoapUI-NG/SoapUI-Pro-5-1-2-hangs-on-Mac-OS-X-10-8-5/td-p/95626
Read more

Salesforce Auto generate renewal Opportunity with Line Items (i.e. Opportunity Products)

Image
First,  let's take a look at the business scenario of this.  Each Account(customer) have a set of opportunities and its Line Items which also know as Products of that Opportunity. Once the salesperson enters those opportunity and product details in the Salesforce, those are likely to be renewed (quarterly, yearly...etc) by the customer if they are planning to go ahead with the same vendor in the next year as well. Therefore, we need to again enter the same data into Salesforce which is almost similar to the previous details which are a time-consuming tedious task.    Our objective is to automate this renewal scenario. What are the available options Writing a class which is invoked by a Visualforce page to create the new opportunity and line items (by acquiring data through SOQL in the Apex class). Writing a trigger to fire on the opportunity once the particular conditions are met. Configuring a process builder follows by a flow to create the op
Read more

Salesforce Create multiple child records based on a number field in the parent using flow

Image
For this example, I'm using salesforce flow to create Ramp plans (child object) based on a number value field in opportunity (parent object) The flow starts from a process builder after an Opportunity closed won In here my number value field is  Contract Term Length (In Months) This is kind of a custom loop which iterate   the   Contract Term Length  Final flow diagram Start by creating an Auto launched flow Let's create the variables we need to store the object data. Note: Please check my previous post to get an idea to create variables you need. First, we need to get the opportunity ID To do that we are adding a Get Records element to the canvas Then store the Opportunity Id on VarT_Opportunity ID In the same panel allocate the value for VarT_ContractTermLength Add a decision element  Configure two outcomes as following Then add an Assignment Element  If the contr
Read more