how to update few fields in an xml payload and keeping all other same in payload using dataweave.

Question

I am using following dw code to change months and years in "*" :- %dw 1.0 %output application/xml

test : { (flowVars.sample.temp mapObject { ($$) : $ unless $$ ~= "years" otherwise "" , ($$) : $ unless $$ ~= "months" otherwise ""
}) }

but it is giving me :-

 <diff>-4</diff>
 <diff>-4</diff>
 <years>*</years>
 <years>0</years>
 <months>10</months>
 <months>*</months>
 <days>1202400.0</days>
 <days>1202400.0</days>

where as i want something like this:-

 <diff>-4</diff>
 <years>*</years>
 <months>*</months>
 <days>1202400.0</days>

input xml is:-

 <diff>-4</diff>
 <years>0</years>
 <months>0</months>
 <days>1202400.0</days>

Answer 1

Best Answer

Jul 17 at 09:24 AM, Phil Hulme answered with:

Sorry, copy paste errors from OP . For different values you nest the 'when .. otherwise ..' clauses. I have switched to as :string as well.

  test : { 
      (flowVars.sample.temp mapObject { 
          ($$) : '#' when ($$ as :string) == "months" 
          otherwise ('*' when ($$  as :string) == "years" otherwise $)    
  }) }

Add comment · Show 7

10 |1200 characters needed characters left characters exceeded

Abhishek Solanki · Jul 17 at 11:08 AM 0

Share

Thanks @Phil Hulme : it worked as expected.

Abhishek Solanki · Jul 20 at 10:50 AM 0

Share

@Phil Hulme : Is there any way i can update the attribute value as well. e.g in one xml below i want to update the "id" attribute only from "abc" to "*".

     <element1 id="abc">abc-time change</element1>
     <element2>cdf</element2>
     <element3>xyz</element3>
 </check>

Phil Hulme Abhishek Solanki · Jul 20 at 11:18 AM 0

Share

Try this;

 %dw 1.0 
 %output application/xml skipNullOn = "attributes"
 
      ---
  element1 @(id: '*' when payload.element1.@id == 'abc' otherwise payload.element1.@id) :payload.element1

it assumes input is just the element1 line so needs to go into your overall weave at the appropriate place. NOTE: skipNullOn = "attributes" removes any attributes in the output if they have a null value to deal with the case of id not being present in the input.

Abhishek Solanki Phil Hulme · Jul 20 at 12:16 PM 0

Share

It is giving below xml which is wrong:_

 <element1 id="*">abc-time change</element1>
 <element1 id="*">abc-time change</element1>
 <element1 id="*">abc-time change</element1>

i want other elements to be as is and only want to change the "id" value. I am using following dataweave script:- (payload is in flowVar) %dw 1.0 %output application/xml

test : { (flowVars.change.check mapObject (payload2,index2) -> { (index2) : element1 @(id: '*' when flowVars.change.check.element1.@id == 'abc' otherwise flowVars.change.check.element1.@id) :flowVars.change.check.element1 })

}

Show more comments

Abhishek Solanki · Jul 21 at 05:01 AM 0

Share

@Phil Hulme : The "id" attribute can be present with any xml element. Currently i have 3 xml elements out of which only one has "id" attribute. Number of xml elements are also not fixed. i can have any number of elements with in root tag.

Phil Hulme Abhishek Solanki · Jul 21 at 07:50 AM 0

Share

That is possible but starts to get a bit messy.

This input;

 <check>
 <element1 id='abc'>abc-time change</element1>
 <element2 id='123'>e1</element2>
 <element3>e2</element3>
 <otherField>some value</otherField>
 </check>

through this transform;

 %dw 1.0 
 %output application/xml skipNullOn = "attributes"
 
      ---
      
  check:(payload.check mapObject { 
      ($$ as :string) @(id: '*' when payload.check."$($$ as :string)".@id == 'abc' otherwise payload.check."$($$ as :string)".@id) :$
  })

gives this output;

 <check>
     <element1 id="*">abc-time change</element1>
     <element2 id="123">e1</element2>
     <element3>e2</element3>
     <otherField>some value</otherField>
 </check>

Answer 2

Jul 17 at 08:42 AM, Phil Hulme answered with:

Where you have repeated for the months you have created a second element. Hence you get two lines in the output for each line in the input. one set with year value replaced and one set with month value replaced. You need to combine the "year" and "month" conditions like this.

 test : { 
     (flowVars.sample.temp mapObject { 
         ($$) : $ unless ($$ ~= "years" and $$ ~= "months") otherwise "*"         
 }) }

Add comment · Show 2

10 |1200 characters needed characters left characters exceeded

Abhishek Solanki · Jul 17 at 08:52 AM 0

Share

@Phil Hulme:-

how about if i need to assign years to "*" but months to "#"?

Abhishek Solanki · Jul 17 at 08:55 AM 0

Share

moreover the solution provided for "*" is also not working. Pls find the o/p given:-

 <diff>-4</diff>
 <years>0</years>
 <months>0</months>
 <days>1202400.0</days>

so i need to use :- test : { (flowVars.sample.temp mapObject { ($$) : $ unless ($$ ~= "years" or $$ ~= "months") otherwise ""
}) }*

what if i need to map these two elements to two different values such as years to * but months to # ?

Answer 3

Jul 21 at 06:17 AM, Aradhana Mohanty answered with:

Add this piece of code: test : { (flowVars.sample.temp mapObject { ($$) : '#' when ($$ as :string) == "months" otherwise ('*' when ($$ as :string) == "years" otherwise $)
}) }

Add comment

10 |1200 characters needed characters left characters exceeded

Answer 4

Jul 21 at 10:44 AM, Sai Manvitha answered with:

Add test : { (flowVars.sample.temp mapObject { ($$) : '#' when ($$ as :string) == "months" otherwise ('*' when ($$ as :string) == "years" otherwise $) }) }

Add comment

10 |1200 characters needed characters left characters exceeded

Main menu

how to update few fields in an xml payload and keeping all other same in payload using dataweave.

4 Replies

Your answer

Like this question?

Who's following the question

Related Questions

Sign up for our dev newsletter

Search form

how to update few fields in an xml payload and keeping all other same in payload using dataweave.

4 Replies

Your answer

Like this question?

Who's following the question

Related Questions

Sign up for our dev newsletter