CODEWITHSUNDEEP
arraysjsonmulesplitter
james
james

Reputation: 451

Mule collection splitter with JSON

I have a JSON that looks something like the one pasted below. I am trying to extract each individual record and push it onto a queue. How would I extract each record in Mule? I've been trying to use the collection splitter and foreach loop, but I can't figure out how to get this to work. 

{
  "locations": {
    "record": [
      {
        "id": 8817,
        "loc": "NEW YORK CITY"
      },
      {
        "id": 2873,
        "loc": "UNITED STATES"
      },
      {
        "id": 1501,
        "loc": "NEW YORK STATE"
      }
    ]
  }
}

Upvotes: 4

Views: 12026

Answers (3)

David Dossot
David Dossot

Reputation: 33413

To do this:

  1. Transform the JSON entity to a hierarchy of Java structures
  2. Extract the record list
  3. Split the list

Now in Mule XML config:

<json:json-to-object-transformer returnClass="java.util.Map" />
<expression-transformer expression="#[payload.locations.record]" />
<collection-splitter />
<!-- TODO: dispatch to queue -->

Upvotes: 5

Utsav
Utsav

Reputation: 1603

I am adding one more solution in which returnClass="java.util.Map" works please have a look at code in which you can put the same JSON in the body using http method as POST while sending data from Fiddler or POST man client.

Here in this flow i am directly assigning expression in the Splitter instead of using Expression Transformer. I am using Any Point Studio to make it work.

    <flow name="mule-splitterFlow2" doc:name="mule-splitterFlow2">
        <http:inbound-endpoint exchange-pattern="request-response" host="localhost" port="8081" doc:name="HTTP" path="splitterjson"/>
        <json:json-to-object-transformer returnClass="java.util.Map" doc:name="JSON to Object"/>
        <splitter expression="#[message.payload.locations.record]" doc:name="Splitter">
        </splitter>
        <logger level="INFO" doc:name="Logger" message="#[message.payload]"/>
    </flow>

Upvotes: 1

Rajesh Narravula
Rajesh Narravula

Reputation: 1463

try this, instead of Map put List. That is working fine for me.

<json:json-to-object-transformer returnClass="java.util.List" />
<expression-transformer expression="#[message.payload.locations.record]" />
<collection-splitter />

Upvotes: 1

Related Questions