How to convert string to json object using DataWeave

Question

How do I convert below input string (which will be retrieved from config.yaml properties file) to required json object using Dataweave?

Input:

"ABC:123,DEF:456,GHI:789"

Required Output:

{
    "ABC":"123",
    "DEF":"456",
    "GHI":"789"
}

sudhish_s · Accepted Answer · 2022-08-09 17:08:20Z

3

splitBy and reduce can be used like below

("ABC:123,DEF:456,GHI:789" splitBy ",") reduce ((item, accumulator={}) -> 
    accumulator ++ 
    do
    {   
        var items = item splitBy  ":"
        ---
        (items[0]): items[1]
    })

answered Aug 9, 2022 at 17:08

sudhish_s

6283 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Salim Khan · Accepted Answer · 2022-08-09 19:33:23Z

1

%dw 2.0
output application/json
---

{(("ABC:123,DEF:456,GHI:789" splitBy ",")  map {
    ({ (($ splitBy ":")[0]): (($ splitBy ":")[1])})

})}

answered Aug 9, 2022 at 19:33

Salim Khan

4,31313 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to convert string to json object using DataWeave

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related