Access Json element in Flow Variable - Mule 3.7

Question

Can we access a json element inside flow variables in Mule?

Eg: My flowVar value is { "Input1": { "Value1": "UNITED STATES" } }

How can I access the element 'Value1' using MEL in mule?

Thanks, ROA

Is your flowVar the string representation of the above example or is it a HashMap or Stream or something else? — Chad Gorshing, Feb 03 '17 at 14:37

score 1 · Answer 1 · answered Feb 02 '17 at 16:25

1

try the below expression,

#[json:/Input1/Value1]

answered Feb 02 '17 at 16:25

Senthil c

341
2
3

score 1 · Answer 2 · edited Jun 20 '20 at 09:12

1

You can use dw function or json path expression to achieve this. examples:

[dw('payload.Request.name')]

[json:Request/name]

edited Jun 20 '20 at 09:12

Community

1
1

answered Feb 06 '17 at 04:21

Deep

71
7

score 0 · Accepted Answer · answered Feb 02 '17 at 20:22

Right answer is

#[flowVars.theVariable.Input1.Value1]

but get here you need a lot what to do. You have to create variable appropriately to match your description. Also name of the variable is missed but you need it anyway. Here is code

    <flow name="AccessFlowVariable">
        <poll doc:name="Poll">
            <fixed-frequency-scheduler frequency="10000000"/>
            <logger message="Flow started" level="INFO" doc:name="Logger"/>
        </poll>
        <dw:transform-message doc:name="Transform Message">
            <dw:set-variable variableName="theVariable"><![CDATA[%dw 1.0
%output application/java
---
{ "Input1": { "Value1": "UNITED STATES" } }]]></dw:set-variable>
        </dw:transform-message>
        <logger message="#[flowVars.theVariable.Input1.Value1]" level="INFO" doc:name="Logger"/>
        <logger level="INFO" doc:name="Logger"/>
    </flow>

and here is result

Your output on DW is Java, so the resulting type is (and is shown in your image above) is java.util.LinkedHashMap. So the dot notation works, I think he is asking that the flowVar is a string and not a hashmap. — Chad Gorshing, Feb 03 '17 at 14:29

score -1 · Answer 4 · answered Feb 03 '17 at 12:38

"Can we access a json element inside flow variables in Mule?": Yes we can access json element inside flow variable.

"How can I access the element 'Value1' using MEL in mule?" Let says if you have stored this json in flow variable (xyz) then you can access it using the bellow syntax: flowVars.xyz.Input1.Value1

Access Json element in Flow Variable - Mule 3.7

4 Answers4

[dw('payload.Request.name')]

[json:Request/name]