JOLT transformation modify overwrite - replace element value in array

Question

I am working on JOLT library to perform a change to the json values.

For key-value items I found a solution using

"operation": "modify-overwrite-beta"

But when it comes to edit values inside the arrays I encounter problems.

Let's have for example this JSON:

{
  "parentModule": [
    {
      "childModule": {
        "arrayModule": [
          "KK",
          "VV"
        ]
      }
    }
  ]
}

SPEC I am using

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "parentModule": {
        "*": {
          "childModule": {
            "arrayModule": [
              "TT",
              "RR"
            ]
          }
        }
      }
    }
  }
]

The result I want is that the array is totally override , but currently it is replacing only the first value.

Result expected:

{
 "parentModule": [
    {
      "childModule": {
        "arrayModule": [
          "TT",
          "RR"
        ]
      }
    }
  ]
}

Is there any way to:

completely override the array?
change values conditionally, for example if TT => change to AB, else if RR than write BB ?

Thanks

Barbaros Özhan · Accepted Answer · 2022-03-09 12:48:03Z

2

You can use shift transformations along with # operators in order to represent the fixed element values for the new lists to be created.

For the first case( if we have "arrayModule": ["KK", "VV"] for the input ) :

 [
   {
     "operation": "shift",
     "spec": {
       "parentModule": {
         "*": {
           "childModule": {
             "arrayModule": {
               "#TT": "&4[&3].&2.&1[]",
               "#RR": "&4[&3].&2.&1[]"
             }
           }
         }
       }
     }
   }
]

the demo1 :

And for the second ( if we have "arrayModule": ["TT", "RR"] for the input ) :

 [
   {
     "operation": "shift",
     "spec": {
       "parentModule": {
         "*": {
           "childModule": {
             "arrayModule": {
               "*": {
                 "TT": { "#AB": "&6[&5].&4.&3" },
                 "RR": { "#BB": "&6[&5].&4.&3" }
               }
             }
           }
         }
       }
     }
   }
]

the demo2 :

while setting proper ampersand levels to reach the desired key names at several levels respectively.

answered Mar 9, 2022 at 12:48

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

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

2 Comments

Nadir Bertolasi Over a year ago

Thankyou for your answer @Barbaros, can you pls explain what this sintax refers to "&6[&5].&4.&3" to understand it better

Barbaros Özhan Over a year ago

Hi @NadirBertolasi &6 stands for traversing 6 times { in order to grab key name parentModule, &4 for childModule, &3 for arrayModule, and [&5] represents the indexes under parentModule object. You're welcome.

Collectives™ on Stack Overflow

JOLT transformation modify overwrite - replace element value in array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related