How to get a value from an array in Mule 4

Question

I wanted to get a value in an array without using absolute array positioning. Here is my json payload.

{ 
  "xyz":{ 
    "abc":[ 
      { 
        "account":[ 
          { 
            "value":"savings"
          }
        ]
      }
    ]
  }
}

How to get the value savings using Data Weave..

and how do you like to select the element? – machaval Nov 04 '19 at 14:27 — machaval, Nov 04 '19 at 14:27

score 2 · Answer 1 · answered Nov 04 '19 at 14:26

2

This dataweave:

%dw 2.0
output application/json
---
payload..value[0]

will produce:

savings

answered Nov 04 '19 at 14:26

utechtzs

score 2 · Accepted Answer · answered Nov 04 '19 at 14:31

2

You can also do that. I supposed you don't want to use at all indexes and that there is only one key value in the payload:

%dw 2.0
output application/json

var data = {"xyz": {"abc":["account":[{"value":"savings"}]]}}
---
data..value reduce $

answered Nov 04 '19 at 14:31

Sébastien Colas

Hi Sebastien., Thank you for the answer ! It is working fine but may I know what are those dots in middle?? If I am giving 3,4 dots then also it is working fine – khaja aminul hussain Nov 04 '19 at 15:00
Please read https://docs.mulesoft.com/mule-runtime/4.2/dataweave-selectors – utechtzs Nov 04 '19 at 15:30

2 Answers2