Search code examples
jsonmuleesbjsonpath

Mule ESB: How do I get a partial match on a Choice node


I have the following flow:

<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns:tracking="http://www.mulesoft.org/schema/mule/ee/tracking" xmlns:json="http://www.mulesoft.org/schema/mule/json" version="EE-3.5.0" xmlns="http://www.mulesoft.org/schema/mule/core" xmlns:core="http://www.mulesoft.org/schema/mule/core" xmlns:doc="http://www.mulesoft.org/schema/mule/documentation" xmlns:http="http://www.mulesoft.org/schema/mule/http" xmlns:spring="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/current/mule-http.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/json http://www.mulesoft.org/schema/mule/json/current/mule-json.xsd
http://www.mulesoft.org/schema/mule/ee/tracking http://www.mulesoft.org/schema/mule/ee/tracking/current/mule-tracking-ee.xsd">
    <json:object-to-json-transformer name="Object_to_JSON" doc:name="Object to JSON"/>
    <flow doc:name="HelloWorldFlow1" name="HelloWorldFlow1">
        <http:inbound-endpoint doc:description="This endpoint receives an HTTP message." doc:name="HTTP" exchange-pattern="request-response" host="localhost" port="8081" contentType="application/json" path="mule/getBalance"/>
        <json:json-to-object-transformer doc:name="JSON to Object" returnClass="java.util.HashMap"/>
    <choice doc:name="Determine Bank" >
            <when expression="#[message.payload.get('uid') == 'ABC']">
                <set-payload value="When ABC case" doc:name="F Acct"/>
            </when>
            <otherwise>
                <set-payload value="#['Default case, payload:  ' + payload + ', payload.get(\047uid\047): ' + payload.get('uid')]" doc:name="SOF Bank"/>
            </otherwise>
        </choice>
    </flow>
</mule>

I try to match the uid of ABC to ABC, and I get a successful mathc, see below

C:\curl>type input2.txt
{ "uid" : "ABC" }

C:\curl>curl -H "Content-Type: application/json" -i -d @input2.txt http://loc
ost:8081/mule/getBalance
HTTP/1.1 200 OK
Date: Mon, 21 Jul 2014 07:06:05 -0700
Server: Mule EE Core Extensions/3.5.0
Content-Type: application/json
X-MULE_SESSION: rO0ABXNyACNvcmcubXVsZS5zZXNzaW9uLkRlZmF1bHRNdWxlU2Vzc2lvbi7rd
7GGKAwAFWgAFdmFsaWRMAA1mbG93Q29uc3RydWN0dAAmTG9yZy9tdWxlL2FwaS9jb25zdHJ1Y3QvR
d0NvbnN0cnVjdDtMAAJpZHQAEkxqYXZhL2xhbmcvU3RyaW5nO0wACnByb3BlcnRpZXN0AA9MamF2Y
dGlsL01hcDtMAA9zZWN1cml0eUNvbnRleHR0ACdMb3JnL211bGUvYXBpL3NlY3VyaXR5L1NlY3Vya
Q29udGV4dDt4cAFwdAAkMjdmNDdiNTAtMTBlMC0xMWU0LTk2NDYtMDAyMTVlNmIzZDkwc3IAJWphd
dXRpbC5Db2xsZWN0aW9ucyRTeW5jaHJvbml6ZWRNYXAbc/kJS0s5ewMAAkwAAW1xAH4AA0wABW11d
dAASTGphdmEvbGFuZy9PYmplY3Q7eHBzcgAkb3JnLm11bGUudXRpbC5DYXNlSW5zZW5zaXRpdmVIY
TWFwndHZ72dFzgADAAB4cHcMP0AAAAAAABAAAAAAeHEAfgAJeHB4
X-MULE_ENCODING: UTF-8
Content-Length: 13
Connection: close

What I need to do now is to try to match on just the first three characters of the uid

In other words Given the following JSON object

{ "uid" : "ABC002" }

I want to get a hit on a when condition with just the first three letters (ABC)

So I keep the original flow, and change the JSON object to

{ "uid" : "ABC002" }

... and I get the following response:

C:\curl>type input2.txt
{ "uid" : "ABC002" }

C:\curl>curl -H "Content-Type: application/json" -i -d @input2.txt http://localh
ost:8081/mule/getBalance
HTTP/1.1 200 OK
Date: Mon, 21 Jul 2014 07:11:35 -0700
Server: Mule EE Core Extensions/3.5.0
Content-Type: application/json
X-MULE_SESSION: rO0ABXNyACNvcmcubXVsZS5zZXNzaW9uLkRlZmF1bHRNdWxlU2Vzc2lvbi7rdtEW
7GGKAwAFWgAFdmFsaWRMAA1mbG93Q29uc3RydWN0dAAmTG9yZy9tdWxlL2FwaS9jb25zdHJ1Y3QvRmxv
d0NvbnN0cnVjdDtMAAJpZHQAEkxqYXZhL2xhbmcvU3RyaW5nO0wACnByb3BlcnRpZXN0AA9MamF2YS91
dGlsL01hcDtMAA9zZWN1cml0eUNvbnRleHR0ACdMb3JnL211bGUvYXBpL3NlY3VyaXR5L1NlY3VyaXR5
Q29udGV4dDt4cAFwdAAkZWM3OTlmZjEtMTBlMC0xMWU0LTk2NDYtMDAyMTVlNmIzZDkwc3IAJWphdmEu
dXRpbC5Db2xsZWN0aW9ucyRTeW5jaHJvbml6ZWRNYXAbc/kJS0s5ewMAAkwAAW1xAH4AA0wABW11dGV4
dAASTGphdmEvbGFuZy9PYmplY3Q7eHBzcgAkb3JnLm11bGUudXRpbC5DYXNlSW5zZW5zaXRpdmVIYXNo
TWFwndHZ72dFzgADAAB4cHcMP0AAAAAAABAAAAAAeHEAfgAJeHB4
X-MULE_ENCODING: UTF-8
Content-Length: 64
Connection: close

Default case, payload:  {uid=ABC002}, payload.get('uid'): ABC002

As you can see it does not hit the when condition with an input string ov ABC002

The when Condition I used was

<when expression="#[message.payload.get('uid') == 'ABC']">

How can I change this expression so that it will only check the first three characters of the incoming string ?


Solution

  • Try it this way and it should work

    <when expression="#[message.payload.get('uid').startsWith('ABC')]">
    

    Hope this helps.