Message Enricher in Mule

Message Enricher in Mule

One common scenario involves the need to enrich an incoming message with information that isn’t provided by the source system. You can use a content enricher if the target system needs more information than the source system can provide.

Consider a message from a source system contains a zip code but the target system needs the two letter state. A message enricher can be used to lookup the state using the zip code from an enrichment resource. The enricher calls out to the enrichment resource with the current message (containing the zip code) then enriches the current message with the result.

This is a very simple flow with one-way inbound and outbound endpoints, and which acts as part of an order processing pipeline. This flow uses an enricher to add a state flow variable to the current message with the state that the stateLookup endpoint returns. The ‘target’ attribute defines how the current message is enriched using a MessageEnricher which uses the same syntax as expression evaluators.

Here we are using Message Enricher in mule 3 in Anypoint studio 6.2

Message Enricher modifies some part of payload without affecting whole payload.

for eg. if i have 3 attributes id, name and age and name and i want to modify the attribute name from the value coming from database then in this case we can use message enricher.

We are using MYSQL db with same schema and table that i used in database connector tutorial.

Here is flow of message enricher, We are giving input by POST request which transformed into java array by transform message 1 and then message enricher modifies original payload by database output provided bt transform message 2.

sublow is connected by main flow via flow reference.

There are two main fields are there in message enricher : Source & Target

Source : It is the attribute or data which will merge with original payload like in our case NAME attribute coming from db is Source.

Target : It is the attribute which will change. Like in our case name attribute of original payload.

path : /message

url : http://localhost:8085/api/message

method : POST

 input :

Output :

Project XML code :

<?xml version="1.0" encoding="UTF-8"?>

<mule xmlns:db="" xmlns:metadata="" xmlns:json="" xmlns:tracking=""
xmlns:dw="" xmlns:http=""
xmlns="" xmlns:doc=""
xmlns:spring="" xmlns:xsi=""
    <http:listener-config name="HTTP_Listener_Configuration" host="" port="8085" basePath="/api" doc:name="HTTP Listener Configuration"/>
    <db:mysql-config name="MySQL_Configuration" host="localhost" port="3306" user="root" password="********" database="demodata" doc:name="MySQL Configuration"/>
<flow name="mainFlow">
<http:listener config-ref="HTTP_Listener_Configuration"
path="/message" doc:name="HTTP" />
        <dw:transform-message metadata:id="bc275a92-358b-44ae-8e1b-04c92d823991" doc:name="Transform Message 1">
            <dw:input-payload mimeType="application/json"/>
            <dw:set-payload><![CDATA[%dw 1.0
%output application/java
payload map ((payload01 , indexOfPayload01) -> {
age: payload01.age,

        <foreach doc:name="For Each">

            <enricher doc:name="Message Enricher">
                <flow-ref name="subFlow" doc:name="subFlow"/>
                <enrich source="#[payload.NAME]" target="#[]"/>


        <json:object-to-json-transformer doc:name="Object to JSON"/>
        <set-payload value="#[payload]" doc:name="Set Payload"/>


<sub-flow name="subFlow">
        <db:select config-ref="MySQL_Configuration" doc:name="Database">
            <db:parameterized-query><![CDATA[select NAME from info where ID=1]]></db:parameterized-query>
        <dw:transform-message doc:name="Transform Message 2">
            <dw:set-payload><![CDATA[%dw 1.0
%output application/java
NAME : payload[0].NAME

No comments:

Post a Comment

If you have any doubt, please let me know

© 2020

Share on :

Mule 4:

XML to JSON in mule 4 Web service consumer VM Validation in Mule 4 Until Successful
Sub flow Set Variable & Remove Variable Set Transaction ID Scatter Gather Round Robin
Consume Restful Service CRUD in Mule 4 Parse Template Object to JSON Load Static Resource
JSON to XML Invoke Idempotent Filter ForEach Flat file to JSON
Fixwidth to JSON First Successful File Execute Error Handling
Email Dynamic Evaluate Custom Business Event CSV to JSON Copybook to JSON
Choice Router Async RabbitMQ

Mule 3:

Database Connector Async CXF Attachement XSLT
Mongo DB Cache scope Custom Business Event Gzip Compress Expression
SMTP For Each Expression Javascript Filter Reference
Salesforce Message Enricher Groovy Parse Template Idempotent
VM Poll Invoke Ruby Message
Webservice consumer Python Transformer reference Message Property Not
Collection Aggregator First Sucessful Catch Exception Strategy Reference Exception Strategy Or
Choice Message Chunk Aggregator Choice Exception Strategy Global Exception Strategy Schema Validation
Custom Aggregator Scatter Gather Custom Exception Strategy Batch Processing MEL
M Unit RAML Map Operator API Mocking Dataweave

Converter Tools :

JSON to XML Converter XML to JSON Converter Decimal to Binary Decimal to Octal Binary to Decimal
Binary to Hexadecimal Binary to Octal Hexadecimal to Decimal Hexadecimal to Binary Hexadecimal to Octal
Octal to Decimal Octal to Binary Octal to Hexadecimal Number to Words Converter Text to Hex Converter
Hex to Text String to Binary Converter Binary to String Converter Word to HTML Converter Word to PDF Converter
JSON to YAML Converter CSV to JSON Converter XML to XSLT Converter XML to YAML Converter
JSON to CSV Converter JSON to TSV Converter CSV to TSV Converter CSV to XLS Converter

Image Tools :

PNG to JPG Converter PNG to BMP Converter PNG to GIF Converter JPG to PNG Converter JPG to BMP Converter
JPG to GIF Converter GIF to PNG Converter GIF to JPG Converter GIF to BMP Converter PNG to PDF Converter
JPEG to PDF Converter JPG to PDF Converter BMP to PDF Converter GIF to PDF Converter

String Utilities :

Reverse String Random String Generator Base64 Encoder Base64 Decoder Words Counter
Remove Accents Remove Duplicate Lines Remove Empty Lines Remove Line Breaks Remove Similar Lines
Sort Text Lines Reverse Text Lines Random Words Generator

Number Utilities :

Square Root Calculator Random Number Generator Area of Circle Calculator Date Calculator

Other Tools :

Find IP of Website Password Generator URL Encoder URL Decoder lorem ipsum Generator
IP to Hostname Port Checker JSON Escape JSON Unescape

Free Rest APIs for Testing :

GET Sample Rest APIs POST Sample Rest API PUT Sample Rest API PATCH Sample Rest API DELETE Sample Rest API
Login Sample Rest API User Registration Sample API User Registration Unsuccessful Sample Rest API Delay Response