How to dynamically set JSON field name in Mule 4

Question

JSON received from API.

{
  "success": true,
  "timestamp": 1645988822,
  "base": "EUR",
  "date": "2022-02-27",
  "rates": {
    "AED": 4.140586,
    "AFN": 102.662987,
    "ALL": 121.380824,
    "AMD": 538.7856,
    "ANG": 2.016644,
    "AOA": 559.803561
  }
}

I am parsing JSON through this way in data weave expression but it gives error

%dw 2.0
output application/json
---
{
    "Result":
    {
        "Data":payload.rates.{Currency}        // Currency=AED  
    }
}

Desired JSON output should be as follow

{
    "Result":
    {
        "Data":4.140586
    }
}

The example output includes incorrectly a DataWeave script. I'll edit to fix it and the rest of the format. Please read the formatting help for the future. — aled, Feb 27 '22 at 21:33

score 3 · Accepted Answer · answered Feb 27 '22 at 21:31

3

You are using an incorrect syntax. payload.rates is an object so you can just use the dynamic selector:

%dw 2.0
output application/json
var selectedCurrency="AED"
---
{
    "Result":
    {
        "Data": payload.rates[selectedCurrency]
        
    }
}

Output:

{
  "Result": {
    "Data": 4.140586
  }
}

answered Feb 27 '22 at 21:31

aled

21,330
3
27
34

Thanks alot, Your solution solved my problem.. – Adil Abdullah Mar 06 '22 at 21:03

score 1 · Answer 2 · answered Feb 28 '22 at 01:18

1

Try Below

Input:

{
  "success": true,
  "timestamp": 1645988822,
  "base": "EUR",
  "date": "2022-02-27",
  "rates": {
    "AED": 4.140586,
    "AFN": 102.662987,
    "ALL": 121.380824,
    "AMD": 538.7856,
    "ANG": 2.016644,
    "AOA": 559.803561
  }
}

Dataweave

%dw 2.0
output application/json
---
{
    "Result":
    {
        "Data":payload.rates.AED        
    }
}

Output:

{
  "Result": {
    "Data": 4.140586
  }
}

answered Feb 28 '22 at 01:18

Harsha Shivamurthy

466
2
6

I've tried that but it doesn't solve my problem. – Adil Abdullah Mar 06 '22 at 21:03

How to dynamically set JSON field name in Mule 4

2 Answers2