top of page

DataWeave programming challenge #7: Modify certain values from a JSON structure



 

Other posts from this series:

 

In this post:

 


Try to solve this challenge on your own to maximize learning. We recommend you refer to the DataWeave documentation only. Try to avoid using Google or asking others so you can learn on your own and become a DataWeave expert!


💡 Tip: Instead of trying to write the whole code yourself, browse in the documentation for any function that would do the work for you 👀



Input


Consider the following JSON input payload:


{
    "name": "a",
    "object": {
      "name": "b",
      "l": [
        {
          "other": "c",
          "list": [
            
          ]
        },
        {
          "thisname": "def",
          "list": [
            {
              "this": "500e",
              "l": [
                {
                  "finalname": "f"
                },
                {
                  "finalname": "ghijk"
                }
              ]
            }
          ]
        }
      ]
    },
    "array": [
      {
        "thisname": "h"
      },
      {
        "xyz": "abc123"
      }
    ]
  }


Explanation of the problem


Create a DataWeave script that will update all the values to uppercase, except the ones in which the field equals thisname.


For example, the first field name with the value "a" has to be transformed to "A". However, the field thisname with the value of "def" should stay the same.



Expected output


In this case, the expected output would be:


{
  "name": "A",
  "object": {
    "name": "B",
    "l": [
      {
        "other": "C",
        "list": [
          
        ]
      },
      {
        "thisname": "def",
        "list": [
          {
            "this": "500E",
            "l": [
              {
                "finalname": "F"
              },
              {
                "finalname": "GHIJK"
              }
            ]
          }
        ]
      }
    ]
  },
  "array": [
    {
      "thisname": "h"
    },
    {
      "xyz": "ABC123"
    }
  ]
}




Clues


If you're stuck with your solution, feel free to check out some of these clues to give you ideas on how to solve it!


Clue #1

Clue #2

Clue #3

Clue #4



Answer


If you haven't solved this challenge yet, we encourage you to keep trying! It's ok if it's taking longer than you thought. We all have to start somewhere ✨ Check out the clues and read the docs before giving up. You got this!! 💙


There are many ways to solve this challenge, but you can find here some solutions we are providing so you can compare your result with us.


Solution #1

Solution #2


Feel free to comment your code below for others to see! 😄


Subscribe to receive notifications as soon as new content is published ✨








820 views7 comments

7 коментарів


Sudiptaa
Sudiptaa
13 черв. 2023 р.

Used tree: %dw 2.0 output application/json import * from dw::util::Tree --- payload mapLeafValues ((value, path) -> if(path.selector contains 'thisname') value else upper(value) )

Вподобати
Alex Martinez
Alex Martinez
13 черв. 2023 р.
Коментар для:

Woohoo! Super simple. Love it! Thank you for sharing :D

Вподобати

I went with a recursive solution: %dw 2.0 output application/json fun capitalizeObject(item: Object) = do{ fun matchItem(item) = item match{ case item is Object -> item mapObject ((value, key, index) -> if(key as String == 'thisname') {(key): value} else {(key): matchItem(value)}) case item is Array -> item map ((item, index) -> matchItem(item)) case item is String -> upper(item) } --- matchItem(item) } --- capitalizeObject(payload)

Вподобати
Коментар для:

That pesky stack overflow, I'm not sure how to rewrite this in the same format using tail recursion and match, hard to conceptualize. Might give it another go when I get some free time. Thanks for posting these challenges, I enjoyed this one!

Вподобати

Shyam Raj Prasad
Shyam Raj Prasad
13 черв. 2023 р.

My solution is similar to yours with extra type check of string.


%dw 2.0 output application/json import * from dw::util::Tree --- payload mapLeafValues ((value, path) -> if(!(path[-1].selector == "thisname") and value is String) upper(value) else value )

Вподобати
Alex Martinez
Alex Martinez
13 черв. 2023 р.
Коментар для:

always the first to comment. nice!!

Вподобати
bottom of page