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, 2017 at 09:24 AM, phulme 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

_abhi_solanki · Jul 17, 2017 at 11:08 AM 0

Share

Thanks @Phil Hulme : it worked as expected.

_abhi_solanki · Jul 20, 2017 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>

phulme _abhi_solanki · Jul 20, 2017 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.

_abhi_solanki phulme · Jul 20, 2017 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

_abhi_solanki · Jul 21, 2017 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.

phulme _abhi_solanki · Jul 21, 2017 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, 2017 at 08:42 AM, phulme 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

_abhi_solanki · Jul 17, 2017 at 08:52 AM 0

Share

@Phil Hulme:-

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

_abhi_solanki · Jul 17, 2017 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, 2017 at 06:17 AM, aradhanamohanty123 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, 2017 at 10:44 AM, manvitha answered with:

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

Add comment · Show 1

10 |1200 characters needed characters left characters exceeded

jagadeesh_mri · Dec 02, 2017 at 06:32 AM 0

Share

you are a perfect example of a copy cat.

Main menu

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

Search form

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